How to re-calculate YearTotal based on requirement when it is dynamic member
Hello everyone,
I am trying to calculate the % of net sales for my GL accounts.
All my GL accounts are setting Account Type is Expense/Revenue and Time Balance is flow:
When I calculated by month, it showed correctly.
But when I see data at year total, it is a rollup of 12 months.
My member "Whatif calculation 03" is from Plan Element dimension.
My question is:
Is there any way to recalculate YearTotal as the average of 12 months in this case?
It should show 100%, not 1200%.
Thanks and have a nice day!
Tagged:
0