How to fix to one decimal

[danialier]

Hello,

I have the following formula which gives me the result but with a bunch of decimals. How can I fix this to just showing one decimal ?

= sum({<[Product Line]={'Hardware'}>}Units)/sum({<[Product Line]={'Supplies'}>}Units)

thanks,dani

[Nicole-Smith · Accepted solution]

num(sum({<[Product Line]={'Hardware'}>}Units)/sum({<[Product Line]={'Supplies'}>}Units),'#,##0.0')

[#3]

Hi,

fromat it with num():

num(sum({<[Product Line]={'Hardware'}>}Units)/sum({<[Product Line]={'Supplies'}>}Units) , '#.##0,0')

RR

[MK_QSL]

NUM(YourExpression, '#,##0.0')

[#5]

Hi Nicole,

fast as lightning ;-))

Regards

Roland

[#6]

Try this

under Number in the format pattern type #,##0.0

[danialier]

excellent ! thanks