I have several decimal fields in one database with a precision of 15 and a scale of 3 (DECIMAL (15,3)).
On my interface if I put a decimal with more than 12 precision digits the node Write to Data Store Entity is always failing. I already tested using a floatingpointfield and also a textfield (where I converted the text do decimal only to persisting purposes) to understand why this is happening.
Do you have any ideas how to overcome this? Because I need to consider decimal numbers up to 15 precision digits .
Discussion posts and replies are publicly visible
I think what you are trying to achieve is to be able to store 15 digits before the decimal point and 3 digits after the decimal point. If that's the case, you will need to change the data type of the column to DECIMAL(18,3) in the database. DECIMAL(15,3) cannot store a value that is bigger than 999,999,999,999.999
© 2023 Appian. All rights reserved.