Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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!

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question