Question

Decimal field with more than 8 digits after the separator

0

Hi! I have a decimal field where I need to store 10 digits after the separator. I know that decimal fields in mendix support only 8 digits after separating it. Any way around this?

asked 2020-10-14

Patricia Birckholz

1 answers

Tim v Steenbergen · Answer 1 · 2020-10-15

There is no easy way around this. Even AppStore app FormatNumber does not increase the max number of 8 digits.

Your best option is to store your attribute in a string and use AppStore module Math for your calculations (if any). See https://mathenginetestapp-sandbox.mxapps.io/p/simple, add “0.12345678 / 100” or "1.2345678901234 + 1.2345678901234” to the formula, to see it at work.