Formula help

[Rajesh_27]

Dear Members,

I am trying to build a formula details of which is provided in the attachment, can someone please help.

Thanks

[aatalai]

IF [month]<3*[Quarter] or [month]> 360+3*[quarter] then 0 else 1 endif

[Rajesh_27]

Hi aatalai,

Thanks for helping me out on this, i believe In alteryx we have to use an equal sign to each component of the OR statement in a formula tool. have tried copying the formula but its not working.

Thanks again your help.

[aatalai · Accepted solution]

@Rajesh_27 are the data fields in number format? e.g. float or double