5 Replies Latest reply on Sep 15, 2018 1:48 AM by Simon Runc

    Subtracting two measures

    chandrakanth k

      Hello All,

       

      I have created two calculated fields to get number of recs to be prepared and approved. Now I want to find the difference between these two.

       

      My First Calculated field "Calculation2 " - IF [Team (group)]="Recs to be prepared by CapG" Then[Number of Records]END  = Value 2583

      My Second Calculated Field "Calculation3 " = IF [Category]= "Uploaded" And [WDS] <> "-" THEN[Number of Records]END = Value 2099

       

      I wrote another calculated field [Calculation3] - [Calculation2] but I am not getting value as Zero.

       

      Need Help

       

      Regards,

      Chandrakanth.K