Calculations with Field Type Int64

[mathias_schnoor]

Hey!

When I worked with large number from my postgres table than the greates bigint (int 64 too) is 8999999999999999999

for numbers greater as bigint I can use type numeric.

When I make a Int64 field with the value 8999999999999999999 Alteryx returned 9000000000000000000

Other example:

Postgres binint value 1234567891012345678

Alteryx returned the Int64 value 1234567891012345600

what is the matter?

Exists a Type like postgres numeric in Alteryx?

Mathias

[BenG]

While there currently is a limitation in the way the formula tool works that will not allow numbers larger than what will fit in a Double, there are two things I can help with:

- If you convert to a fixed decimal large enough to hold your numbers and results, the Summarize tool can do calculations on these numbers without losing precision.

- We are looking at the larger problem of handling larger numbers accurately.  We are a ways off, but we are working on it.

Thanks,
Ben

[mathias_schnoor]

Thank for your support,

Mathias

[novita]

Hello all,

is there any update on this problem?

Best Regards,
Rajesh

[harsh_alang]

Starting version 23.1 Alteryx has added INT64 support in Formulas. Users will now be able to leverage large numbers in their calculations without losing precision.