IF condition + Calculation

[Amy123]

Hi Team,

need a logic and formula :_

If BO = 0 then TC Amount - FC Amount ELSE IF BO! = 0 then FC Amount - BO 

How to write this logic can anyone help

TC Amount	FC Amount	BO	Variance
50000	50000	0	0
122332	2221	2221	0
21132	23232	23232	0

[atcodedog05]

Hi @Amy123 

Here is how you can do it. Your formula was almost there. If it doesnt meet both the condition output is null.

Formula:

If [BO] = 0 then [TC Amount] - [FC Amount] 
ELSEIF [BO]!= 0 then [FC Amount] - [BO]
Else Null()
Endif

Workflow:

Hope this helps : )

[bensilv]

Hi @Amy123 

Can you elaborate on what the issue is? It looks like your formula would work perfectly fine in Alteryx! Just use a formula tool with that logic.

If you have 2 conditions, you'll need an ELSE condition to catch the rest.

[bensilv]

For the ELSE condition, you can implement either mine or @atcodedog05 's solution (depends if you want it to be null or a 0)

Speedy as always @atcodedog05 😉

[Kamran1991]

@atcodedog05  has the solution for almost every Alteryx problem, I have noticed in last 6 month. Keep it up. 🙂