3 Replies Latest reply: Jul 17, 2017 4:35 PM by Lohit Inguva RSS

    KPI - Actual year and previous year

    Joaquin Nieto Cruz

      Hi everyone, I just want to know the correct formula (in KPI) to show the figure of the previous year when selecting a year or month. I have used the next formula but it's not working at all:

       

      Sum({$<AÑO={$(=max([AÑO]-1))}>}[Unidad Ventas])

       

      The one in actual year is working correctly, so it is only this one I need to correct.

       

      Thank you!!!

       

      Joaquin.