Skip to Content

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 02, 2015 at 05:35 PM

    Hi Rich,

    Try:

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

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04, 2015 at 04:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded