You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to re-calculate YearTotal based on requirement when it is dynamic member

in Planning 14 comments

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!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!