Round Function Display

[#1]

I am using the round function. Is there a way to force the result to display the position to the right of the decimal even when it is zero? For example with this code

Round(Sum (SLA_MTH_TON_00005),.1)

When SLA_MTH_TON_00005 equals 19.0 it displays as 19. I want it to keep the format with one place to the right of the decimal for consistency sake as most of the numbers do not come out to an even whole number.

[#2]

I have two"rounds" becuase if the expression is true it does the first "round" which leaves the answer as a whole number for lines 196,197. ect. If the expression is not true it rounds it to one decimal place. The format of the answer varies according to the line.

[#3]

Can you put your QVW file???....i try to help you.....

I just need you put on zip format!!!!!

[Miguel_Angel_Baeyens]

Hello Jim,

You may try

Num(Sum(SLA_MTH_TON_00005), '#,##0.0')

which force the number to show one decimal number, even when the result is integer. There's no need for Round() as your problem doesn't seem to be the rounding of decimal positions, but the way you want them displayed.

Besides, your complete expression (my untested suggestion) may be

IF(MATCH(SLA_RECORD_SORT, '0001', '0002', '0003', '0004') > 0 AND MATCH(SLA_LINE, 196, 197, 199, 200, 201, 203, 205, 209, 230) > 0, Num(Sum(SLA_MTH_TON_00004), '#,##0.0'), Num(Sum(SLA_MTH_TON_00004), '#,##0.0'))

Make sure that you are using "," as thousands separator and "." as decimal separator.

Note that some parentheses or brackets may not be properly closed.

Hope that helps.