RangeSum Issue

[dineshm030]

Hi All,

I am creating the report with RangeSum function. I am facing some issue with that function.

I want in Jun-18 field should be adding with previous two month's value.

Expression:

RangeSum(Before(Sum({<IMSMonthName,IMSYear,DATAPERIOD={">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-2),'YYYYMM'))<=$(=max(DATAPERIOD))"}>}NVALUE)/1000000,0,3))

Thanks in advance.

[swuehl]

If you want a time range from Apr 18 to Jun 18, you need to select Jun 18 in DATAPERIOD to set the max(DATAPERIOD) accordingly or change your search expression in the set expression accordingly.

[dineshm030]

Hi Stefan,

If i will show 12 months the values are correct except Sep-17. i am using the below expression.

In Sep-17, it should be adding Sep,Aug and July value.

Expression:

RangeSum(Before(Sum({<IMSMonthName,IMSYear,DATAPERIOD={">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-11),'YYYYMM'))<=$(=max(DATAPERIOD))"}>}NVALUE)/1000000,0,3))

[dineshm030]

Hi All,

Kindly refer the screenshot. I am using rangesum function. I am strugging with that function.

The Issue is in OCT-17 and SEP-17. Kindly help me.

Expression:

RangeSum(Above(Sum({<IMSMonthName,IMSYear,DATAPERIOD={">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-11),'YYYYMM'))<=$(=max(DATAPERIOD))"}>}NVALUE)/1000000,0,3))