Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
8 subscribers
Views
2292 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
When I try to use fn!mod() I am getting different answers in Appian than the ans
davidj578
over 9 years ago
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
0
PhilB
A Score Level 1
over 9 years ago
I suspect your problem is down to the notation you're using here: 2^31 - 1
Using the power function above it seems to work fine...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
PhilB
A Score Level 1
over 9 years ago
I suspect your problem is down to the notation you're using here: 2^31 - 1
Using the power function above it seems to work fine...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data