Hi,
I am trying to get the YoY % increase from A to B. however the set analysis i am using is somehow returning inflated percentages.
A= sum({$<CFYTDFlag={1}>}PartCost
B=sum({$<LFYTDFlag={1}>}PartCost
where CFYTD is the current sales and LYFTD is the previous year in the master calendar.
and these two are master dimensions.
I now want the YoY % increase from LFYTD to CFYTD.
I tried
((sum({$<CFYTDFlag={1}>}PartCost)-sum({$<LFYTDFlag={1}>}PartCost))
/(sum({$<LFYTDFlag={1}>}PartCost)))*100
but this is giving me the % above 100%.
Can someone tell me how I can get the year on year increase?
Thanks