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)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, 

 

I'm not sure what you're asking for exactly but sounds like the conditional column can create what you need. 

Go to add a column, conditional column 

 

for example