Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sushma RamakrishnanSushma Ramakrishnan 

Using formula fields how to round off decimal value to whole value

Hi All,

I want to display a value say 95.2% as 95%
I have written the below formula field : 
TEXT(MyField__c * 100) & '%'

The above one gives me : 95.2%.

Thanks in Advance...!
Best Answer chosen by Sushma Ramakrishnan
Dhanya NDhanya N
Hi Sushma,

Please check the below formula:

TEXT(ROUND(MyField__c * 100, 0)) & '%'

Thanks,
Dhanya

All Answers

Dhanya NDhanya N
Hi Sushma,

Please check the below formula:

TEXT(ROUND(MyField__c * 100, 0)) & '%'

Thanks,
Dhanya
This was selected as the best answer
Gabriel ArribasGabriel Arribas
Hi Sushma,

You could create a custom field 'Percent', with 0 decimals. On this way will remove decimal numbers.
I hope you solve your issue.

 
mritzimritzi
Try this alternate method: 
TEXT(  ROUND( MyField__c,0 )
) & '%'

Assuming that "Myfield__c" is a number field, and the formula field has return type "Text"

Mark this as Best Answer, if this helps.
Rohit K SethiRohit K Sethi

Hi Sushma ,

Use the round function before covert to string .

Use this code :

TEXT(Round(MyField__c * 100,0))  & '%'
Thanks.
niharnihar
hi sushma ,rohith,dhanya
Hi All,

TEXT(ROUND(MyField__c * 100, 0)) & '%'

I want to display a value say 95.2% as 95% and 6.7% as 7
I have written the below formula field :
The above one gives me : 95% and 6% 

Thanks in Advance...!