10 Replies Latest reply: Dec 21, 2017 9:29 AM by Sunny Talwar RSS

    Difference & % difference

    Sachin Nataraj



      Can you please help me in getting the correct difference & the % difference of two numbers (column GM 2016; column GM 2017),

      I want to obtain the difference only to non 0 number that are present in both columns.


      I used "fabs(Sum({$<[Year]={"2016"}>}[Gross Margin Actual Year])) - (Sum({$<[Year]={"2017"}>}[Gross Margin Actual Year]))"


      to get the difference as the data in excel is in one column.


      Thank you in advance