Sales Variance: YTD vs LYTD

[erickd1190]

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)

[ayandey18 · Accepted solution]

Add the measure in the Highlighted area

[shraddha_g]

Field name is missing in 2nd Expression.

[ChennaiahNallani]

try

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

[erickd1190]

Thank you all! I noticed it first thing this morning. Sometimes stepping away and coming back helps you notice things you were missing before.

However I am afraid that this has not fixed the issue. Even after the change it is still not calculating, just getting the --.

Any other thoughts?

I appreciate it!

Erick

[erickd1190]

I fixed it!

Turns out I need to adjust my data model to include numeric and text version and use the Text for the expression!

Thank You everyone!