Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to write IF statement with variable in formula tool

PC08
5 - Atom

If [NEW_TIEROPT] = "T" And [AVG_VOL] < [NEW_TIER1VOL] Then ' Activty Charge
A = [AVG_VOL] * [NEW_LIST]
AA = [AVG_VOL]
Else: A = 0 And AA = 0
End If

1 REPLY 1
binuacs
20 - Arcturus

@PC08 You need to define the new variable as new fields in Alteryx then write the formula under each field. Sample workflow is given below

 

binuacs_0-1681937954182.png

 

Labels