on 05-19-2011 1:06 PM
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
Thanks&Regards,
narasimha.
Hello,
You could try create a CKF with the exception aggregation of MAX value and for the exception characteristic select 0gl_account.
This will display the MAX value for the month, except for the gl_account it should aggregate (sum) as expected.
Hope this helps,
Regards,
Diogo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
define a CKF for Accumulated balance and in the exception aggregation define it as Max for char GL account,
The report values will remain as such only when it is displaying result that this will come into picture and will show result as 200 for GL acc 1000 and 400 for GL accoutn 2000. The overall result will be shown as 600.
regards,
Arvind.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.