Multiple IFS Statements

quims

Hi Alteryx Community,

I'm Quims and new to Alteryx, i would like to seek an advise on how to place IFs correctly in a formula function.

My Statements are:

If [Revenue] is equal or less than 0 then [Allocation] will be same as [Revenue]

If [Expense] is equal or less than 0 then [Allocation] will be same as [Expense]

If [Revenue] [Expense] is greater than 0 then [Allocation] will calculate based on formula i stated

Default formula:

([Total Revenue]*[Expense])/[Total Expense]

SN# 1 and 2 is formula by default but when applying it to SN# 3, 4 and 5, shouldn't 0 in Allocation column. I want it to reflect in Allocation column the number from Expense and Revenue if i got 0 results whether in Total Revenue or Total Expense Columns.

Thank you in advance.

BenMoss

Hi!

You need to use a formula tool, with the fieldname set as 'Allocation'

You can then use the function below as the formula...

If [Revenue] <= 0 then [Revenue]

ElseIf [Expense] <= 0 then [Expense]

ELSE ([Total Revenue]*[Expense])/[Total Expense]

ENDIF

Ben