Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
trying to calculate previous three months from user selection i.e
if the user selected 201804 the expression should retrieve calculation for : 201804,201803,201802
tried it with :
SUM({<YYYYMM={"$(='>=' & date(AddMonths(max(FULL_DATE),-3),'YYYYMM'))"},MM=,YYYY=>}AMOUNT)
but it retrieves 0 , (not the actual result)
any ideas?
advanced thanks
Hi ilan,
Please try below highlighted :
SUM({<YYYYMM={"$(='<=' & date(AddMonths(max(FULL_DATE)),'YYYYMM'))"},MM=,YYYY=>}AMOUNT)
YYYYMM={"<=$(=AddMonths(Max(YYYYMM)))>=$(=AddMonths(Max(YYYYMM),-3))"}
Thanks,
Arvind Patil
Hi ilan,
Please try below highlighted :
SUM({<YYYYMM={"$(='<=' & date(AddMonths(max(FULL_DATE)),'YYYYMM'))"},MM=,YYYY=>}AMOUNT)
YYYYMM={"<=$(=AddMonths(Max(YYYYMM)))>=$(=AddMonths(Max(YYYYMM),-3))"}
Thanks,
Arvind Patil
thank you very much,
below my final expression :
YYYYMM={"<=$(=AddMonths(Max(YYYYMM),0))>=$(=AddMonths(Max(YYYYMM),-3))"}
Welcome
Thanks,
Arvind Patil