Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sundar84sundar84 

Formula field rounded values

Friends

 

Actually formula field values takes rounded values if any calculation made. I need to restrict the rounded value in formula field.

I want to show the actual value with out rounded.

 

For ex: Netweight__c/2204 (52,428/2204) this is a formula field it returns rounded value. actaul value is 23.78 but it returns 23.79.  Please let me know your suggestion to resolve this issue

 

Thanks

Sundar

Best Answer chosen by Admin (Salesforce Developers) 
Starz26Starz26

VALUE(LEFT(TEXT(52428/2204), FIND(".",TEXT(52428/2204))+2))

 

 

All Answers

Starz26Starz26

VALUE(LEFT(TEXT(52428/2204), FIND(".",TEXT(52428/2204))+2))

 

 

This was selected as the best answer
sundar84sundar84

Thanks  Starz.