Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to calculate data from a moment in the past with a formula and set analysis, but it does not work like this
=Sum({<Year_Month={"=$(=MonthName(AddMonths(Year_Month,-3)))"}>}FC_KG)
Year_Month has format 'mon YY', such as Apr 2017
Thanks for you answer
Kind regards
Sorry above calculation is for current date selections ,
Please use this :
=SUM({<Year_Month = {"$(=Date(AddMonths(Max(Year_Month),-3),'MMM YYYY'))"}>}FC_KG)
Regards,
Sunitha