Multi-Condition IF THEN ELSE statement

Question

Hi Everyone,

I'm new with Alteryx and appreciate if someone could tell me in plain language what the below statement in Alteryx mean.

Thanks in advance for the help.

IF [value1]-[value2]+[value3] then 1 else 0 endif

my main problem is that i don't get the logic and mathematic behind this condition.

Qiu · Answer

@Hammad_Rashid 
I again doubt you are a Robot or AI. 😂

Hammad_Rashid · Answer

The statement you provided is a conditional statement written in Alteryx's expression language. Let me break it down for you in plain language:

IF [value1] - [value2] + [value3] is true
THEN output 1
ELSE output 0
ENDIF

Here's the logic behind it:

* Calculate the result of [value1] - [value2] + [value3].
* If the result is true (non-zero), the condition is satisfied, and the output is 1.
* If the result is false (zero), the condition is not satisfied, and the output is 0.

In other words, the expression checks whether the value obtained by subtracting [value2] from [value1] and then adding [value3] is greater than zero. If it is, the output is 1; otherwise, the output is 0.