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) ?
Tagged:
0