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
8
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!