Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You may try conditional statement like:
=If(floor(Variable1)=Variable1, Variable1, Num(Variable1,'#,##0.0'))
Now replace Variable1 with your expression.
Even Integer means, Do you have any different Types. Would you provide sample data and expected result?
You may try conditional statement like:
=If(floor(Variable1)=Variable1, Variable1, Num(Variable1,'#,##0.0'))
Now replace Variable1 with your expression.
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?