# Round % formula to 1 decimal

This formula, titled InsCoGrowth2013-2014, returns a % with 2 decimals:

if Sum({@Counter2013},{@InsuranceOrGroupName}) = 0 then "N/A" else

totext ((Sum ({@Counter2014},{@InsuranceOrGroupName}) - Sum({@Counter2013},{@InsuranceOrGroupName})) % Sum({@Counter2013},{@InsuranceOrGroupName})) & "%"

I tried putting this into a rounding formula:

Round({@InsCoGrowth2013-2014},1)

and I get the 'A number or currency amount is required here' error.

How can I get this to return just one decimal (rounded up, not truncated)?

Thanks!

##### Abhilash Kumar replied

Hi Rich,

Try:

**if Sum({@Counter2013},{@InsuranceOrGroupName}) = 0 then "N/A" else**

**totext ((Sum ({@Counter2014},{@InsuranceOrGroupName}) - Sum({@Counter2013},{@InsuranceOrGroupName})) % Sum({@Counter2013},{@InsuranceOrGroupName}),1) & "%"**

**-Abhilash**