how to stop Decimal Point automatic round off

Hi Parag,

Your calculated values goes beyond Number (Decimal) acceptable size in byte.

Decimal in Appian can hold 8 bytes and approximately ±1.79769313486231570E+308
(15 significant decimal digits) and Integer numbers can range from -2,147,483,647 to 2,147,483,647 (or from -231+1 to 231-1 in scientific notation).
Hence, Your calculated value is 0.9999999800000001 which is 16 decimal digit. So this is a limitation in Appian.

Solution for bigger calculation is to use fixed () , if you can handle this as text type and store your data as text type only. Thanks

Hi Parag,

Your calculated values goes beyond Number (Decimal) acceptable size in byte.

Decimal in Appian can hold 8 bytes and approximately ±1.79769313486231570E+308
(15 significant decimal digits) and Integer numbers can range from -2,147,483,647 to 2,147,483,647 (or from -231+1 to 231-1 in scientific notation).
Hence, Your calculated value is 0.9999999800000001 which is 16 decimal digit. So this is a limitation in Appian.

Solution for bigger calculation is to use fixed () , if you can handle this as text type and store your data as text type only. Thanks

You need to take care of the round problem because if you have a number like: 4.85999999 the round conversion place 4.8600 because it's and automatic function that Appian applies