I'm trying to recreate an excel formula into Alteryx and stuck. Basically, =MOD(-3,12) in excel is equal to 9. Writing the same formula MOD(-3,12) in Alteryx gives -3.
Any ideas why that is and how to get the same excel result of 9?
Yes, Direct Alteryx formula is not giving the same value when we compare with excel. I have used formula to arrive the result which matches with Excel MOD. Attached workflow fyi.
MOD to Match with Excel.yxmd
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.