Skip to Content
0

Summation till current month day in each year

Sep 21, 2017 at 08:54 PM

36

avatar image

Hello

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
0

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:

https://blogs.sap.com/2013/09/20/standard-bex-variables-in-sap-bi-for-caldaymonth/

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:

https://archive.sap.com/discussions/thread/3600183

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.

0