Need some help writing Conditional Formulas

[JPAEP]

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

[IraWatt]

@JPAEP you definitely can. Would you be able to give a quick example table with your variables and desired output?

[grazitti_sapna]

@JPAEP, try this.

Thanks!

[JPAEP]

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.

[JPAEP]

That would work, but I need it in one condensed formula if possible.

[IraWatt]

Ah thanks @JPAEP, looks like @grazitti_sapna has already sorted that logic for you.

[grazitti_sapna · Accepted solution]

Hi @JPAEP, try this

IIF(DateTimeDiff([CON Finish],[CON Start],'days')=0, 1, DateTimeDiff([CON Finish],[CON Start],'days'))

Thanks!

[JPAEP]

Awesome! Thanks to you and @IraWatt for your help.

[grazitti_sapna]

@JPAEP , Glad me and @IraWatt  were able to resolve your query.

Thanks!