4 Replies Latest reply on Jul 21, 2018 11:43 AM by Ken Flerlage

    Using Calculated field correctly?

    Mayur Runwal

      How do I use below formula correctly so that I get accurate answer? I tried using case for if statement but no luck. Appreciate any help to move forward.

       

      SUM(({ FIXED [Delivery Group]:MAX([DG Count])})) - SUM(({ FIXED [Delivery Group],[Tenency]='Dedicated':MAX([Unassigned])}))