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."
Hi, I need the exact output but in return with decimal type without rounding the decimal point numbers, can someone help here please
vishalini said:exact output but in return with decimal type without rounding the decimal point numbers
What exactly do you mean by that? Can you visualize this somehow?
Hi Stefan Helzle ,
well! I am trying to subtract two decimal values and the out put I am getting it decimal value with roundup
ex: local!a: 1234567.79,
local!b:0.01,
local!c: local!a - local!b
local!c returns 1234567.8 but I need the out put with actual decimal value with out roud-up value i.e., 1234567.78
I tried to use fixed function to get the exact value but it returns the text type as out put, I need the output as decimal type.
Then you are fine. When Appian displays any value, it needs to convert it into text. Your screen can only display text. And it does so using a simple approach rounding values to one digit.
Now, my question is, what do you want to do with that output? Display it on screen, then use the text() function to do so.
I need use that value in one of the decimal type field as an input
Well, then you are good to go.
Thank you Stefan Helzle , It worked with text() function