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

Dynamic Calc Accounts not adding up in Department dimension

Accepted answer
edited Aug 9, 2023 5:47PM in Planning 12 comments


Content (required):

We have two dynamic calc accounts in our workforce cube that are not adding/aggregating up in the department hierarchy.

They are both set to Dynamic Calc and Addition plan types in workforce. The account member formulas are below. For the W5810000, I commented out the ELSE because I thought that was causing it, but it is still not adding up to the total for COS Depts.

Is there something missing in the member formula? What else could be affecting this?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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