1 Reply Latest reply on Jul 8, 2016 11:21 AM by Michael Hesser

    One filter result divided by the other

    Andrew Hay

      Capture.JPGI 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.

        • 1. Re: One filter result divided by the other
          Michael Hesser

          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


          • Technically, you can combine the first two into a single equation
          • I didn't test this, so it may not work


          let me know if it does the job!