Cumulative aggregation to specific day in a week

[former_member305977]

Hello IBP Experts,

We have a requirement to aggregate past and the current values on a specific day eg Monday. Please find the screenshot for values . Values in the Past ( 20 ) and Current ( 20 ) should be added to value on next Monday ( 200 ) . So the expected value on monday should be ( 20+20+200 = 240) and in the future the values should remain as is.

Is there anyway to achieve this without LCODE.

Regards,Uday

[former_member305977]

Hello Irmi,

Thanks for your response.

We were able to aggregate all the past and current values to the current bucket using IBP_CAGGR as you mentioned ( KF3@PERPRODCUST= IBP_CAGGR( "KF2@PERPRODCUST",''SUM'', ''FORWARD'' , ''PASTCURRENT'') ) .

Can you tell us how to aggregate that value to monday after setting 1 using attribute ?

Regards,Uday