I need to put this in a STRAIGHT table as I need to use mini charts to show a trend.
I need the KPI_ID down the side and also to put the Months across the top of the table so I need to use expressions to do this.
Some KPIs are calculated as SUM(Num)/SUM(Denom), some are just SUM(Num)...some are more complicated so I wanted to keep all of this logic within a variable (vFormula)
I was then going to put my expression as =Sum({<Month={"$(vFinYear_Apr)"}>}$(vFormula)) but I can't get it to work...any ideas?
If my variable is just Num (with no preceding 😃 then it does give the correct result for that, but anything more complex and it doesn't work.
