Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

calcualtion problem for Accumulated bal KF in BEx Query designer

Hi Experts,

In My Bi report there is field called Accumulated balances.I would like to display as follows:

IN the below example the accumulated balance per account should display as balance at last month of year where as overall result should display as total of individual accumulated balances per each account

GL account Month Accumulated balance

1000 1 100

1000 2 200

Result 200

2000 1 300

2000 2 400

Result 400

over all result 600(400+200)

I have tried some combination in key figure properties under calulation tab but i am unable to get the required output.

Please guide me



Not what you were looking for? View more on this topic or Ask a question