Rounding numbers in formula 2

[jlhart76]

I have a report that calculates the percentage meeting certain elements using the formula:
if DENOMINATOR=0 then "N/A"
else totext (PERCENT)*100

I want to round the number to a 0.1 digit, but using truncate or round command gives me a whole number [11.73 is rounded to 11.0]

Is there another command I can use? I've tried formatting it to percent, using the decrease decimal command, etc. but it won't allow me to do either.

 

[lbass]

Try:

if DENOMINATOR=0 then "N/A"
else totext(PERCENT*100,2)

The "2" will define the number of decimals.

-LB

 

[jlhart76]

Worked perfectly! Thanks, you're a peach!