Allocation with calculated driver not producing the desired results.
I need to create an allocation where expense accounts per entity need to get redistributed/adjusted with a percentage from the total expenses divided by total entity. I created a calculated driver as follows:
[BR_PRC_ALLOC] := ([BR_Expenses],[NoRule],[NoDriver],[Input]) / ([BR_Expenses],[E5857],[NoRule],[NoDriver],[Input]) * (([NoRule],[NoDriver],[Input]) / ([NoRule],[NoDriver],[Input]));
Where "E5857" is the total entity. I can see the driver % in Smart View ("BR_PRC_ALLOC"), however the amounts are not getting multiplied by the driver value.
Can you please help?
|Input||Input||Input||Allocation In||Allocation Out||Net Change||Net Balance|