Hi,
we use a query entity to retrieve decimal numbers to check data inserted.
After testing, we see that Appian have a strange behaviour with decimal digits, according to the integer digits of the number.
For example, when we insert a number with 5 integer digits, it shows 2 decimal digit, while, when we insert a number of 6 integer digits, it shows 1 decimal digit. With 7 (or more) integer digits, no decimal digits are visible.
This is not a DB problem, because, if I use an expression rule, with a conversion on decimal number, I get the same problem.
Here some examples:
I try also "fixed" function, but sometimes it doesn't works.
Is there a workaournd to get the right value?
Thanks.
Regards.
Juri Monti
Discussion posts and replies are publicly visible