Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF statement

I am looking for a way to create an IF statement that works to create the "New Column"   If ( cuts = 1, " Savings amount", "0")    I am having trouble creating the "New Column" Values based off t...
Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    it's unclear your desired output but I can suggest your column will look like

    New Column = IF([cuts] = 1, [Saving], 0)
az38's avatar
az38
Community Champion
6 years ago

Anonymous 

it's unclear your desired output but I can suggest your column will look like

New Column = IF([cuts] = 1, [Saving], 0)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Apologies for the confusion but this is exactly what I needed. I had "0" in my formula so that was the reason it did not work.