Num expression as integer when integer, else 1 decimal place

[pauluk__]

Hi,

I'm trying express a mix of different numbers as either an integer or to 1 decimal place.

Is there anything I can do just in the Num expression that would achieve this?

Num(Sum(Number), '#,##0.0') places everything at 1 decimal place, even integers.

Thanks for the help.

[Anil_Babu_Samineni]

Even Integer means, Do you have any different Types. Would you provide sample data and expected result?

[tresesco · Accepted solution]

You may try conditional statement like:

=If(floor(Variable1)=Variable1, Variable1, Num(Variable1,'#,##0.0'))

Now replace Variable1 with your expression.

[pauluk__]

Hi,

Yes that is a good way of checking this thanks. I was looking more to see if it was possible in the Num expression formatting?