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

    Difference & % difference

    Sachin Nataraj

      Hello,

       

      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

       

      Sachin