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

Member Formula account doesn't rollup to Parent Entity

Summary:

I have two statistical accounts: TaxRate and TaxCalc. TaxRate stores a rate, while TaxCalc applies this rate to FCCS_Sales and stores the result (FCCS_Sales * TaxRate). I set the Consol Operator for TaxRate to Never to prevent aggregation across dimensions. TaxCalc calculates correctly for base entities but does not roll up to the parent entity.

When I changed the Consol Operator for both TaxRate and TaxCalc to Addition and modified the member formula to run only for base entities, the parent entity still showed no value.

Is there a way to roll up the calculated values to the parent entity ( keeping in mind that TaxRate doesn't need to be rolled to the parent as it gives incorrect values are parent entity) ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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