10 Replies Latest reply on Sep 17, 2016 9:06 AM by tingting chen

    LOD Calculation Field Problem?

    Sandeep Kotha

      Hi All,

       

      I have used the below code to find the difference between the two fields. This is my requirement.

       

      RUNNING_SUM(AVG([Field1]))-RUNNING_SUM(SUM([Field2]))

       

      I have got all the values as correct except the grand total as shown below snapshot.

             

              Field 1            Field 2              Difference

       

      You can see : Grand total 49691-22327 should be "27364" . But it is in negative which is wrong. Formula is not taking for grand total.

       

      Could someone help me with some code so that Grand total will also get reflected as per the formula?

       

      Best Wishes,

      Sandeep