Skip to main content
New Participant
Apr 3, 2025 11:02 AM UTC
Question

Mathematical Operation returning ∞ infinity

How can i check what value appian returns?

6 replies

stefanhelzle0001
Brainy
Apr 3, 2025 11:30 AM UTC
How can i check what value appian returns?

What exactly do you want to check for?

New Participant
Apr 3, 2025 11:34 AM UTC

The subtraction result. ITs +1 than expected result;

34235435345 - 1159628.16 = 34234275716.84

but instead i am geting 34234275717.74 written in db

mathieud0001
Genius
Apr 3, 2025 11:37 AM UTC

What is the type in the DB?

mikes0011
Brainy
Apr 3, 2025 12:31 PM UTC

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.)

The Expression Guru
konduruc733182
Inspiring
Apr 3, 2025 1:19 PM UTC

Hello [mention:0f8ce127fcfe4143b68e494203a97314:e9ed411860ed4f2ba0265705b8793d05] ,

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