We are facing issue like the value is Number(Decimal) when user enters - 1595739.56 it gets round of to – 1595740. Which is a concern here. Also any number which is of 7 or more than 7 digit are getting round of.
We understand appian recommends the uses of ‘text field’ instead of floating point field, but this will lead to the column type changes in Database because those decimal columns can either be calculated in appian or in database stored procedures, hence as converting the column from decimal to varchar will required us to type cast them from varcharToDecimal before doing any calculation s and those are many fields which are used in calculations. Any urgent help/suggestion is really great help to me to progress.
Discussion posts and replies are publicly visible
This is just a matter of how Appian displays values. This is also documented.
https://docs.appian.com/suite/help/21.4/Appian_Data_Types.html#number-(decimal)
"For forms, use one of the following Text Functions to display a decimal number as a default value to avoid rounding."
I am facing an issue while comparing two decimal values to find whether one is greater than the other. I tried using fixed and todecimal functions, but the result is not as expected.
2 rule inputs:invoiceTotalAmount (Number Decimal) - value: 99999999999invoiceItemAmounts (Number Decimal Array) - value: {99999999999,2}
Expression:sum(ri!invoiceItemAmounts) > ri!invoiceTotalAmount returns false [Expected: true].
Your example works perfectly for me. Can you share some code?
Your rule inputs are already decimals. There is no need to somehow try to convert them into decimals.
Here is my code, it returns false for me
Please have a look at your test inputs. You entered an integer value which Appian then tries to convert into a decimal. Make it 99999999999.0 and it will work.
oh yeah, it worked. Thanks
Hello Stefan,
Even I am facing similar issue here, I need a sum of list of decimal field values(more than 7 digit value), and required output to be in decimal field with 2 number of digits after decimal point.
sum({7654321.50 , 75973.20})
But I am either getting value rounded of or else it will be in exponential. Could you pls help me with it
hi maaaaj0001 Could you raise this as new thread and post your query please