Forum Discussion
Rolling Returns Issue. please help
Hi All, I want to calculate QTD, MTD, YTD and 1Yr,2Yr and 5 Yr rolling returns based on Category P and I for the attached dataset . when i tried using the quick measure, it fails and gives a error ...
Hi Greg_Deckler ,
Thanks for sharing this links.. i tried with my datset and got the issue. Can you please help if possible
This is 5 yr data which i have shared before...i need to calculate for each column code(CODE1,CODE2...) and for category group 'p' and 'I', i need MTD,YTD and QTD. when i tried its giving me error with result giving me the same value as in value column instead of summing it up MTD,YTD and QTD wise