IF statements

[Alisuzy]

Hi everyone.

I am new to Alterex and must say that I am really enjoying it.

I am having trouble formulating an IF statement. If anyone could help me out I would be very appreciative.

My cols are : Ending Balance (numeric col), P/L balance(numeric col), section (Asset, Liability,Income,Expense).

I am trying to create a formula for:

If Section = Asset or Liability then use the figures from the Ending balance.

If section = income or expense, then use the P/L balance figures.

Ideally, I need a new col with the correct figures populated.

[rafalolbert · Accepted solution]

Hi @Alisuzy,

Formula you're after here is: 

IF ([section ] = "Asset" OR [section ] = "Liability") THEN [Ending Balance]
ELSEIF ([section ] = "Income" OR [section ] = "Expense") THEN [P/L balance] ELSE "" ENDIF

Thanks,

Rafal

#Excume me, do you speak Alteryx?

[Alisuzy]

Thank you so much!!!!