Skip to Content

BEx query output columns calculation in Analysis for office

Dear Experts,

I am ABAPer and new to BEx query. My requirement is given below.

BW team will write the BEx query and the output will shown in SAP Analysis for office(AO).

After getting the output from query in AO, there are few fields in output columns which are editable, now the user may edit the output columns, based on the values provided by user in ouptut columns, we need to calculate and display the result in another field or another output column.

Ex:

Here K21 and L21 are editable fields, if user eners the value in these fields we need apply calculation on these and show the output in M21 column.

For above values, K21 ( Full year forecast 2018) = 1000

L21( % Change 2019 ) = 10%

Calculated column M21( & Sales Net sales ) = K21 + L21%K21

= 1000 + 100 = 1100

Please provide solution for this requirement.

Thank you.

Best Regards,

Chinni

5yp.png (20.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 22 at 05:54 AM

    Hi,

    try this:

    1) Create new column in AFO workbook and use excel formula to calculate desired result.

    or

    2) Create planning function use fox formula to calculate desired result.

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded