4 Replies Latest reply on Jun 19, 2019 11:36 AM by Jeff Shyu

    Percent Difference calculation

    Akrati Kher

      I have two columns on which i have to calculate percent difference.

       

      Column A and Column B

       

      What cal i can use that to find: A-B/ A+B or

      A/sum(A)- % for A

      B/ sum(B)- % for B

      then Difference A-B  or is there any other way to do that?

       

      Also tried the inbuilt percent difference function but not sure how to use that?

       

      Have anyone done this before?

       

      Thanks

      Akrati