Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Raimy]

Happy New Year folks. 

I am finding myself in need of a field which will display at least 4 decimal places, for use in a smartlist. So what about this?

FormatNumber(math(10 / 136),3)&datatype=[number]

Results differ from Library field to expression column. The column gives me what i want, but the library field chops off the last 2 decimal places.

Library Field Output = 0.07
Expression Column Output = 0.0735

Just a quick question on this. Is a Library field limited to 2 decimal places what ever expression i throw at it?

[Hendrik]

Simple decimal fields are indeed always limited to displaying 2 decimal places.

If you need to see more, you should be able to do "FormatNumber([Field,0],3])&datatype=[number]" in an expression column.
Note the added ",0" after the field name, it means you get the "raw" unformated data, so you can format it yourself.

[Raimy]

Thanks very much Hendrik.

[Raimy]

Sorry, i thought that had worked, well it works without the "&datatype=[number]" part, soon as i add that it resorts back to 2 decimals only.

[Hendrik]

Are you sure you included the ",0" in the field name?

I tried this in an Expression Column:
FormatNumber([FPS,0],3])&datatype=[number]

FPS is a decimal field, and some files I have will otherwise show 23.98 instead of 23.976

[Raimy]

This demonstrates my problem really well actually.

I put

"FormatNumber([FPS,0],3])&datatype=[number]" in an expreesion column showing 3 files output =

25
29.883
29.917

Copy & Paste the same expression into a calculated data Library Field. output =

25
29.88
29.92

Iv no idea what's going on here, except forcing the calculated field to number data, also limits the output to 2 decimal places.

[Hendrik]

Like I said earlier, library fields always output only 2 decimals.
If you want to see more, you need to use an expression column.

[Raimy]

Ar ok, im assuming its just for display reasons, and any sort MC performs would be done on the raw data.

Thanks for the help.