4 Replies Latest reply: Apr 18, 2017 8:37 PM by Sebastián Ortiz RSS

    How can I calculate the increase in sales year by year?

    Sebastián Ortiz

      Dear,

      I need help to calculate the increase in sales [Oportunidad.PrecioCliente] year by year [OpDetalle.FechaCierre.autoCalendar.Year] for each product. I have the following table:

       

      2a6b058c62954b19a13e2685c3ac04a2.png

       

      I set the following function but it does not calculate any value

       

      Sum({<[OpDetalle.FechaCierre.autoCalendar.Year]={[OpDetalle.FechaCierre.autoCalendar.Year]}>}[Oportunidad.PrecioCliente])/

      Sum({<[OpDetalle.FechaCierre.autoCalendar.Year]={[OpDetalle.FechaCierre.autoCalendar.Year]}-1>}[Oportunidad.PrecioCliente])

       

      How should I write the formula?

      How can I calculate the increase in sales year by year?

       

      Thanks!