Round % formula to 1 decimal

[former_member406941]

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 · Accepted solution]

Hi Rich,

Try:

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

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

-Abhilash

[DellSC]

Also, there is another way to add a '%' to a number without converting the number to text:

1.  Put the number on your report.

2.  Right-click on it an select "Format Field...".

3.  Go to the Number tab and click on the "Customize" button.

4.  Click on the "Currency Symbol" tab.

5.  Enable the Currency Symbol, set the position to be on the right of the number, and set the currency symbol to "%".

At this point you could use the rounding in the number format to get what you want.

-Dell