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 the above IF statement. 

 

Saving    Cuts     New Column

  92.00       0              0

  23.00      1              23

    15         1              15

     0          0              0  

    12.00    0              0

  900.00    1            900

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)

3 Replies

  • 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. 

  • 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