Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
this is what i have in my app.
I would like to have just thousand , for example 9.532, i would like to see only 10 (rounded)
for 45.735 i would like to see 46
for 19.106 i would like to see 19
I tried to change the format pattern, but i didnt get the result expected.
Any advice how to setup the format pattern?
Thank you!
Use Round()
example =Round(Field)
what about having only the K ? (e.g. for 45.735 i would like to see 46)
What you mean by having only the K??
You can use Num also
=Num(45.735,'##')
as you see now i have on the table 45.735 - i would like to see only 45
Try like this
Round(Field/expression) this will give the desired result
in this way i have 46.000 i would like to have only 46, without the 000
Did you tries the way we suggested it will give the exact result what your excepting
Hi,
change your format pattern to remove everything after the decimal point:
$ #;-$ #
Marcus