0 Replies Latest reply on Apr 16, 2013 7:29 AM by buildstar

    Calculation divide and percentage - Subtract between rows

    buildstar

      Hi,

       

      I have the attached data as in the image.

       

      I want to do (84620 / 301705 - 1)

       

      Both the values come from 2 separate columns and have null values hence I am not able to do the formula and show data in new column.

       

      Or can I subtract same column rows in the tabular report ?

       

      I need to arrive at the value

      -71.95%

       

      for the above example. Please help with a solution to arrive at this number

       

      Thanks