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