Skip to main content
April 3, 2025
Question

Mathematical Operation returning ∞ infinity

  • April 3, 2025
  • 6 replies
  • 0 views

How can i check what value appian returns?

6 replies

stefanhelzle0001
April 3, 2025
How can i check what value appian returns?

What exactly do you want to check for?

April 3, 2025

The subtraction result. ITs +1 than expected result;

34235435345 - 1159628.16 = 34234275716.84

but instead i am geting 34234275717.74 written in db

mathieud0001
April 3, 2025

What is the type in the DB?

mikes0011
Brainy
April 3, 2025

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

konduruc733182
April 3, 2025

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