topic RE: What is the limit of the number type dataitem. in Product Forum

What is the limit of the number type dataitem.

yijiaqi — Wed, 01 Nov 2023 06:49:00 GMT

What is the maimum and minimun of the number type data item.

When it is integer is seems in the range of -2^96+1 - 2^96-1, is it right?

And when it is a decimal, what is the max and min limit?

------------------------------
Jiaqi Yi
developer
Sony
------------------------------

RE: What is the limit of the number type dataitem.

Chakkravarthi_P — Wed, 01 Nov 2023 11:17:00 GMT

Blue Prism uses a 32-bit signed integer, and the valid range is -2,147,483,648 to 2,147,483,647. This is consistent with the standard range for a 32-bit signed integer in programming languages and systems using a similar representation.

I can't remember where I took this, but I have it in my notes from a few years ago.

------------------------------
Chakkravarthi. PR
------------------------------

RE: What is the limit of the number type dataitem.

AndrewPascal — Tue, 07 Nov 2023 17:07:00 GMT

I would also be interested to know the answer. I did a few experiments and wasn't able to find any limit within the range of numbers I could realistically think of ever wanting to use. Sorry @Chakkravarthi. PR, but it definitely isn't 32-bit integer: I've just tested it with a 30-digit number and it worked fine!

------------------------------
Andrew Pascal
------------------------------

RE: What is the limit of the number type dataitem.

yijiaqi — Wed, 08 Nov 2023 00:52:00 GMT

Hi Andrew

I have just solved the issue.

The data type is [Decimal]. It is a 96-bit type. About 29 valid scale in decimalism.

With a scale of 0 (no decimal places), the largest possible value is +/-79,228,162,514,264,337,593,543,950,335 (+/-7.9228162514264337593543950335E+28). With 28 decimal places, the largest value is +/-7.9228162514264337593543950335, and the smallest nonzero value is +/-0.0000000000000000000000000001 (+/-1E-28).

Please refer to this link

https://learn.microsoft.com/en-us/dotnet/visual-basic/language-reference/data-types/decimal-data-type

------------------------------
Jiaqi Yi
developer
Sony
------------------------------