6 Replies Latest reply on Jul 16, 2018 6:16 AM by Hannah Williams

    Calculate the % difference in a calc

    Hannah Williams

      Hi There,

       

      I have this dashboard, I will use the -6.73% (second column) in my example:

       

       

      The % in red shows the % difference between the above 2 numbers. To do this I used to sheets, the second sheet (to get the % difference) used the quick table calculation function (percentage difference), compute using table down, relative to previous.

       

       

       

       

      The issue I have is that I now want to use the percentage difference result in another calculation. Do I need to create a new calc that gives the -6.73% result (rather than using the quick table calculation), how can I do that? or is there another way?

       

       

      Thanks

      Hannah