Skip to Content
0

Bex Query Design Doubt

Jul 05, 2017 at 11:21 AM

32

avatar image

Hi Team,

I have a scenario where I need to achieve the below Requirement through Query in Bex.

I have WBS, Billing date and Billing Value are coming from my DSO.

Now.

1. I have to Get the number of days based on SY_DATUM (This I am able to achieve)

2. my Final output of the Query should be Billing value should be summed up based on the Number of days against to the Each WBS (No WBS should be repeated)

can you please suggest me how this can be achieveable.

Thanks,

G S Ramanjaneyulu

1.png (10.5 kB)
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:06 PM
0

hi

you can build 3 calculated key figures.calculation like:

((SAPvariableTODAY - FORMVARIABLEofbillingdate if not KF ) <=30)*billingval

and

((SAPvariableTODAY - FORMVARIABLEofbillingdate if not KF ) >30)*

((SAPvariableTODAY - FORMVARIABLEofbillingdate if not KF ) <=90)*

billingval

and

((SAPvariableTODAY - FORMVARIABLEofbillingdate if not KF ) >90)*billingval

Share
10 |10000 characters needed characters left characters exceeded