Skip to Content

Bex Query Design Doubt

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 12, 2017 at 12:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded