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 never use this funcion

but did you try

Round(Sum (SLA_MTH_TON_00005), 0.1)

or depends object you are using.....you can format on properties!!!!

[#3]

Sorry.....my answer is wrong....i think you can use a

NUM(your expression, '#,##0.0')

[montubhardwaj]

you can go to the properties-->Number format and then choose "Fixed to" 1 decimal place.

Hope that was helpful.

Cheers,

Sharma

[#5]

That does not seem to work. I still get 19 instead of 19.0. The Round function seems to be overriding the format.

[#6]

did you try this????

NUM((Sum (SLA_MTH_TON_00005),.1), '#,##0.0')

because NUM function with this format force .0!!!!!

[#7]

Sharma,

I can't change it on the number tab because it's not always one decimal. It can vary according to other criteria. When the criteria is for one decimal I want to show that way though.

[#8]

Erico,

Yes I tried that. It's a large expression but here is my exact code. The very last part is where I tried the num function.

IF ((SLA_RECORD_SORT = '0001' OR SLA_RECORD_SORT = '0002' OR SLA_RECORD_SORT = '0003' OR SLA_RECORD_SORT = '0004') AND (SLA_LINE='196' OR SLA_LINE='197' OR SLA_LINE='199' OR SLA_LINE='200' OR SLA_LINE='201' OR SLA_LINE='203' OR SLA_LINE='205'OR SLA_LINE='209' OR SLA_LINE='230') ,Round(Sum (SLA_MTH_TON_00004)),num (ROUND (Sum (SLA_MTH_TON_00004),0.1),'#,##0.0'))

[#9]

But you have a two expression with Round.....and you put just in one....

Did you see at the other post from you.....i sugest change your "large" expression to another with set analisys???

[#10]

Try this

NUM(ROUND(Sum ( {$<SLA_RECORD_SORT={'0001','0002','0003','0004'},SLA_LINE={'196','197','199','200','201','203','205','209','230'}>} SLA_MTH_TON_00004),.1),'#,##0.0')