Fixed Decimal maximun decimal

[isaacmx]

Good Morning, 

Please, can you help me?

How can I use in Fixed decimal the maximum length? I have more than 17 decimal positions (for ABC Costing), I’ve tried a lot of combination, but still lost precision.

An example of that data: (0.00774237375174116)

Thanx in advance!!!

[griffinwelsh]

@isaacmx the fixed decimal data type supports up to 17 decimal positions. You can set the number of decimals by editing the number after the period in Size. For more than 17 you must use data type string to display. You can also use data type double to retain the value, but only 6 decimals will show. You can round to any number of decimals with the formula below where [Field1] is your field and you replace 19 with the number of decimals you want.

round(tonumber([Field1])*pow(10,19),1)/pow(10,19)