4 Replies Latest reply on Nov 30, 2016 6:43 AM by Aldo Fournies

    Calculate Year on Year in the same table without Calculated Field

    Aldo Fournies

      Hello all,

       

      I'm wondering how can I calculate the difference (Value and Percentage) between two fields that are filtering by date. I paste the data here, so you can see my issue:

       

       

      I want to add two new columns:

       

      1.- The difference between 2015 and 2016 in value.

      2.- The difference between 2015 and 2016 in percentage.

       

      I know with a calculated field it could be done, it's exist other way? more fast and  to ensure better performance?

       

      Thanks in advance! Every idea is welcoming!