Hi all,
Have a small issue on variance...let me know the set analysis code for the foll formula....
[ (Actual '13 - Actual '12) / Actual '12 ] * 100
I have applied
sum({$<YEAR= {$(=max(YEAR-1))}>}CTS-----(VVALUE13)
sum({$<YEAR= {$(=max(YEAR))}>}CTS----(VVALUE14)
Created Variable
=(((VVALUE14)-(VVALUE13))/VVALUE13)*100
On month and year selection i am getting the right value...but on summary level it is showing same values....
let me know the reson y it is showing same values....like -89......on selection i m getting wite vale...plz help me
