这样对吗? if([组价项目]="利润",(sumfor(gridname,"企业报价_成本费用_合计","工程名称", "=" ,[工程名称],"楼盘名称", "=" ,[楼盘名称],"组价项目","=","征地和拆迁安置补偿费")+sumfor(gridname,"企业报价_成本费用_合计","工程名称", "=" ,[工程名称],"楼盘名称", "=" ,[楼盘名称],"组价项目","=","勘察设计及三通一平费")+sumfor(gridname,"企业报价_成本费用_合计","工程名称", "=" ,[工程名称],"楼盘名称", "=" ,[楼盘名称],"组价项目","=","建筑安装工程费")+sumfor(gridname,"企业报价_成本费用_合计","工程名称", "=" ,[工程名称],"楼盘名称", "=" ,[楼盘名称],"组价项目","=","住宅小区基础设施建设费"))*cell(row,col-2),if([企业报价_成本费用_合计]=0,round([企业报价_成本费用_单价]*[企业报价_成本费用_数量],2),[企业报价_成本费用_合计]))
|