Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am calculating YTD with two dimension. I am using RangeSum and Above function. I am struggling in Above function. Kindly help me.
Expression:
RangeSum(Above(sum({<IMSMonthName,IMSYear,DATAPERIOD={">=$(=date(AddYears(YearStart(date#(max(DATAPERIOD),'YYYYMM')),-1),'YYYYMM'))<=$(=date(addyears(date#(max(DATAPERIOD),'YYYYMM'),-1),'YYYYMM'))"}>}NVALUE)/1000000,9,RowNo()))
I have hot coded 9. How to achieve this instead of hot coded by month.
Regards,
Dinesh Kumar Mani.
If 9 here indicating month number one less than today's month, you could define a variable and use it in the expression like:
vPreMonth=Num(Month(Today()))-1
Then replace your hard coded number with $(vPreMonth)