If [NEW_TIEROPT] = "T" And [AVG_VOL] < [NEW_TIER1VOL] Then ' Activty ChargeA = [AVG_VOL] * [NEW_LIST]AA = [AVG_VOL]Else: A = 0 And AA = 0End If
@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