When I try to use fn!mod() I am getting different answers in Appian than the ans

When I try to use fn!mod() I am getting different answers in Appian than the answers I am getting in MS Excel. For example:

tointeger(fn!mod(ri!ID,2^31-1))

Where ID = "1234567891011" returns Type Number (Integer) Value 1912278207

ALTERNATIVELY:

=MOD(A1,2^31-1)

Where A1 = 1234567891011 returns 1912277633

Please help me explain why these answers are close but different and how I can get reliable answers from the MOD function for such large numbers.

OriginalPostID-195754

OriginalPostID-195754

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data