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

Financial Reporting Auto Calculation

Received Response
18
Views
1
Comments
edited Feb 15, 2021 3:08PM in Planning 1 comment

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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