3 Replies Latest reply on Jul 11, 2018 3:50 PM 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])}))