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

FRS report percentage calculations based on displayed digits

in General Ledger & Intercompany 1 comment

Hi Team,


We are developing an FRS report, which involves having the actuals and the percentages.


For a specific account 110110 as an example,

YTD Actual - 126.00

YTD Last Year - 0.42


In this case, the variance and percentage variance is calculated as -

Variance = 126-0.42 = 125.58

Percentage Variance = 125.58/0.42=299.0 = 29900%

Percentage Variance calculated by system = 29919.3%

Difference : 19.3%

Kindly let me know how to rectify this error. I believe this error might be due to the fact that the displayed YTD Actual and YTD Last Year are displayed as 2 decimals, but while percentage calculation, more than 2 digits are considered.

We still want to continue rounding them to 2 digits and the system should use the rounded figures for calculation. Is there a way to do that?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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