5 Replies Latest reply: Mar 3, 2017 10:32 AM by Erick Dameron RSS

    Sales Variance: YTD vs LYTD

    Erick Dameron

      Hi all!

       

      I need to create a % variance using a KPI chart.

      To do this I have wrote the following chart expression but am coming up with a -- in the KPI chart.

       

      Can anyone point out what I am doing wrong?

       

      (SUM({$<fYear={'2016/2017'}>}sale)-SUM({$<fYear={'2015/2016'}>}))/SUM({$<fYear={'2015/2016'}>}rate)