I am trying to get the YoY % increase from A to B. however the set analysis i am using is somehow returning inflated percentages.
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.
but this is giving me the % above 100%.
Can someone tell me how I can get the year on year increase?