I want to get a bar graph of the water divided by the Cement but I can't figure out how to do it. I tried this IF ([Material Class]='Water') THEN [Actual Amt] END / IF ([Material Class]='Cement') THEN [Actual Amt] END but that just gave void since it can't be both at the same time. I am sure it can't be that complicated I just can't think.
Hi Andrew;
I'm not quite sure I understand the details, but I think a LOD equation might do the trick. What about these three equations:
Water Ratio
{FIXED [Close Time]: sum(iif([[Material Class]="Water",[Actual Amt],0))}
Cement Ratio
{FIXED [Close Time]: sum(iif([[Material Class]="Cement",[Actual Amt],0))}
Water / Cement Ratio
Water Ratio/Cement Ratio
let me know if it does the job!