I'm sure this is probably pretty easy, but I'm struggling with the "1" in the middle of the formula. But how would I write this in Alteryx?
=IF(O2-K2=0,1,(O2-K2))
Thanks in advance!
Jordan
Solved! Go to Solution.
@JPAEP you definitely can. Would you be able to give a quick example table with your variables and desired output?
So essentially, even though these were finished the same day, I would still want a 1 in the scheduled days to Work Column. So the calc I had was right, just need extra to make it more correct.
That would work, but I need it in one condensed formula if possible.
Ah thanks @JPAEP, looks like @grazitti_sapna has already sorted that logic for you.
Hi @JPAEP, try this
IIF(DateTimeDiff([CON Finish],[CON Start],'days')=0, 1, DateTimeDiff([CON Finish],[CON Start],'days')) |
Thanks!
Awesome! Thanks to you and @IraWatt for your help.