Skip to Content

Summation till current month day in each year

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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:

    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

    Add comment
    10|10000 characters needed characters exceeded