Create a field with the oppossite of the selection

[#1]

Hello!

I have a table with the field ACCOUNT_IDs and STATUS.

Where STATUS could be Selected, Planned, Stopped.

I want to create another field in script to add the options with:

Not Selected (Planned and Stopped)

Not Planned (Selected and Stopped)

Not Stopped (Selected and Planned)

Do you know how could I do this?

Thank you!!!

[Anonymous]

Not clear - if a STATUS is, for example, Planned, what should be the new field value - Not Selected or Not Stopped?