Forum Discussion
Post ProdigyConditional column for # of days employed
The conditional column screen doesn't have the features for complex 'and' conditions. If you edit the code slightly in the formula bar or Advanced Editor, it will allow you to use the Custom Column dialog to write the full statement.
So change the code in formula bar to be similar to this (just an example):
if [a] > 12 and [a] < 15 then "12-15" else "<12"Hit the tick on the left of the bar to save it.
Then go to the Applied Steps and edit the query step. It should open the Custom Column dialog and you can write the statement there.
-----
You can, of course, start fresh with the Add New Column -> custom column
Community ChampionThe conditional column screen doesn't have the features for complex 'and' conditions. If you edit the code slightly in the formula bar or Advanced Editor, it will allow you to use the Custom Column dialog to write the full statement.
So change the code in formula bar to be similar to this (just an example):
if [a] > 12 and [a] < 15 then "12-15" else "<12"
Hit the tick on the left of the bar to save it.
Then go to the Applied Steps and edit the query step. It should open the Custom Column dialog and you can write the statement there.
-----
You can, of course, start fresh with the Add New Column -> custom column
