Skip to Content

BEX Query - Need to Count no of days between Last billing date to current Billing date.

Jul 06, 2017 at 06:29 AM


avatar image
Former Member

Below result need as highlighted field.

Bill No Cust ID Billing Date No of days 1 C001 2 C001 3 C002 4 C001 5 C002

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

1 Answer

Koen Hesters Jul 12, 2017 at 12:16 PM


create 1 keyfigures in your BW dataflow:

-last billing date = billing date (exception aggregation= last value)I

when it is not possible to do this on BW level you can create a formula variable on billing date and set there as well tj exception aggregation on last value

for current billing dat I assume you want today/sy-date, so you can use a SAP standard formula variable TODAY.Use them both in a calculated key figure to get your nr of days in between.



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

Thanks a lot.