 ShowAll Questionssorted byDate Posted Sushma 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%. Best Answer chosen by Sushma Ramakrishnan Dhanya N
Hi Sushma,

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

Thanks,
Dhanya Dhanya N
Hi Sushma,

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

Thanks,
Dhanya
This was selected as the best answer Gabriel 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. mritzi
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 Sethi

Hi Sushma ,

Use the round function before covert to string .

Use this code :

`TEXT(Round(MyField__c * 100,0))  & '%'`
Thanks. nihar
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%