Financial Reporting Auto Calculation

Content

Hello,

We are working with the Auto Calculation feature on Financial Reporting and we noted that "Total Calculation" adds all columns.  But in a column we have variance percent and this should not be added, instead this must be another function.  How we can work around this?

Example:

Account	FY19	FY20	Var	Var %
X00001	1000	1500	500	50%
X00002	2000	0	-2000	-100%
X00003	2000	0	-2000	-100%
Total (AutoCalc Function)	5000	1500	-3500	-150%

In the Total row, the var% instead of -150% it should be -70%

Thanks for your help.