IF Function

Trying to write an IF function that will say "if [transaction type] = "Void" or if [transaction type] = "Refund" then [Purchase Amount] *-1

Basically trying to say if Transaction Type column is Void or Refund then I need the Purchase Amount column to be multiplied by -1. Any tips?

Alteryx-1.docx

Input

Accepted answers

Robin_McIntosh

You need to name the new column.

All comments

Matthew

you've already got it, you just need to finish the statement with "endif"

you also need and "else" statement to cover cases where the if statement is false

if [Txn Type] = 'Void' or [Txn Type] = 'Refund' then

[Purchase Amt] * -1

else

[Purchase Amt]

Endif

DataNath

You need to provide an 'ELSE' clause i.e. what to do if the txn type isn't void or refund, and then end your statement with 'ENDIF' to finish. Something like this for example:

IF [Txn Type] IN ('Void','Refund') THEN -[Purchase Amt] ELSE [Purchase Amt] ENDIF

The above will just return the Purchase Amount as normal (not multiplied by -1) if the Txn Type isn't void or refund. I've also used the 'IN' function so you can just provide a list of possibilities instead of constantly having to type out 'or Field Name = Value'.

Robin_McIntosh

**Edit - Sorry, didn't realize @DataNath already provided the suggestion of IN(....)

In addition to @Matthew and @DataNath, you can simplify by saying If [Txn Type] in('Void','Refund') Then...

carterfleming

Still getting errors

Robin_McIntosh

You need to name the new column.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703