% variance calculation

[kocomandi]

Hello

I kindly need some assistance with the % variance calculation.
Below I have created 4 cross calculations for Actual, Budget, $ variance, and % variance. The $var and % var are calculations based on account type.
I have summed up two accounts nodes and labeled the sume Cash and Cash Equivalents.
However, the % variance for that line item is not calculated correctly. It is the sum of the % calculations above.
How to fix this issue?
Thanks

[N1kh1l]

kocomandi

Could you try setting up the priority of calculation in table and see if it helps. In the builder panel you will find the option towards the end.

Hope this helps !!

Nikhil

[kocomandi]

I tried that but it did not change. The % variance is still wrong.