Hello, I understand that you can have two evals in one line but i keep getting several errors when i try to combine two. This eval is going into the calculated field to pull info from another field as well. Attempted Eval: lower(if(isnull(action),attempted_action,action)), case(action == "OVERWRITTEN", "modified", action == "OPENED", "read", action == "DOES_NOT_EXIST", "deleted", action == "SUPERSEDED", "acl_modified", action == "CREATED", "created") What am I trying to achieve? We want the action to display the attempted action field when the action field is blank. With the attempted action values, there are about 7 values that will appear in the action field. I would like them to be renamed to make the CIM data models in some way.
... View more
