Bex Query Design Doubt

[former_member183425]

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

[kohesco]

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