You need to sign in to do that
Don't have an account?
Tin013
Formula field is rounding up the number
Hi all,
Hope you are all well.
I have a formula field which retries a figure from a look up object -
Price__r.Children_Price__c .
On the Children_Price__c of Price__r object, the actual figure comes out as £69.12 but on the formula field that I have the figure is only coming out as £69.00. How do I make sure so that the formula field doesn't round up the figures please?
Thanks,
It seems that while creating the formula field, you have missed decimal places. You should keep 2 decimal places to achive the desired result. Edit your formula field and fix the problem.
Did this answer your question? if so, please mark it solved.
All Answers
It seems that while creating the formula field, you have missed decimal places. You should keep 2 decimal places to achive the desired result. Edit your formula field and fix the problem.
Did this answer your question? if so, please mark it solved.
You are a genius!