Skip to Content

Summation till current month day in each year

Sep 21, 2017 at 08:54 PM


avatar image


I have data like this in my bex report.

I need to calculate cummulated values separately for each year (0calday will not be on a report) till current month day. For example if today is 2017-09-21 it must sum values from yeach year till 21.09 and omit other caldays (till 2009-09-21, 2010-09-21 etc). On the next day it must calculate till 09-22 etc

is there any standard BEX variable that allows such calculation? If not how to create such one?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
William Ayd Sep 22, 2017 at 12:56 AM

I'm not sure specifically which one you'll need, but here's a good post of all of the standard variables related to time:

If they didn't work but you wanted to see the ABAP behind any of them you may want to look at function module RREX_VARIABLE_EXIT. Check this link for more info:

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks William. I was able to do it with Cell Editor and 0CALDAY restricted by 0CYTCD with required time shift.