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.
