3 Replies Latest reply: Mar 14, 2018 7:19 AM by Sunny Talwar RSS

    Help creating banal calculated column

    Massimo Favaro

      Hello everyone,

      I am trying to create a very easy calculated column in the Data Editor.

      I have a numeric column [Sales] and I'd like a calculated column that's equal to 1 if Sales is <90 and >= 60, and 0 otherwise.

      Shouldn't it be "IF([Sales] < 90 AND [Sales] >= 60, 1, 0)"?

      It keeps saying  something like"No preview. Use a valid expression." and I don't undertand why.

       

      The box where I have to write the code of the calculated column is, moreover, very buggy: sometimes when I press space it moves to the end of the expression and it's very hard to write a complex formula.

       

      Thanks to anyone who may help me.