We have a formula field that calculates savings percentage. The formula is as below,
ROUND((( Total_Saving__c * 100) / Total_balance__c ),2)
where total saving is also a formula field, the formula for total saving is as below,
Total_balance__c - Required_Amount__c
and the total balance is a currency field.
And we are getting the results as follows
Total savings = 287.20
Total balance = 1187.20
Savings percentage = 24.19
But if we do the reverse calculation and calculate 24.19% of 1187.20 on a calculator, the result is 287.18. so there is a difference of 0.2. I am not able to identify the issue in the formula field.