+ Start a Discussion
Tin013Tin013 

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,

Best Answer chosen by Admin (Salesforce Developers) 
Pradeep_NavatarPradeep_Navatar

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

Pradeep_NavatarPradeep_Navatar

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.

This was selected as the best answer
Tin013Tin013

You are a genius!