How can i check what value appian returns?
Discussion posts and replies are publicly visible
vidyakv said:How can i check what value appian returns?
What exactly do you want to check for?
The subtraction result. ITs +1 than expected result;
34235435345 - 1159628.16 = 34234275716.84
but instead i am geting 34234275717.74 written in db
What is the type in the DB?
It's not actually "returning infiniti", it's just showing that output because your first number is well past the integer overflow of just over 2 billion. Just like if you only tried to output the first number by itself.
If you force the first number to evaluate as a decimal instead, you get a more helpful answer:(i figured wrapping the first number in "todecimal()" would do this too, but for some reason it isn't. Appian is a little wonky about data typing though - and I might just be doing something wrong, too.)
Hello vidyakv ,
I hope Mike gave you the explanation of why you see it in such a way, You can try using Big Numbers plugin for these sort of calculations.
community.appian.com/.../big-numbers-functions