alteryx Community

Alteryx Designer Desktop Discussions

IF condition + Calculation

8 - Asteroid

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
4 REPLIES 4
22 - Nova

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 : )

Alteryx

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.

Alteryx

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 😉

11 - Bolide

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

Labels