Hi everyone
I have the following column and trying to transform to create the desired column:
I am in the: | Seniority (desired column) |
Top 25% of my organisation in seniority | Senior role |
Middle 50% of my organisation in seniority | Non-senior role |
Bottom 25% of my organisation in seniority | Non-senior role |
Other | Non-senior role |
[Null] | [Null] |
I've used the Formula tool with the following formula, but unfortunately it's not transforming the "Top 25% of my organisation in seniority" to "Senior role", instead it is transforming it to [Null]. This is depicted in the column below in red text:
I am in the: | Seniority (desired column) |
Top 25% of my organisation in seniority | [Null] |
Middle 50% of my organisation in seniority | Non-senior role |
Bottom 25% of my organisation in seniority | Non-senior role |
Other | Non-senior role |
[Null] | [Null] |
Screenshot of my formula below:
Can someone please help me troubleshoot my IF formula?
Thanks,
KA
IF
IsEmpty([field]) THEN Null() ELSEIF
Left([field],3) = "Top" THEN "Senior role"
ELSE
"Non-senior role"
ENDIF
Cheers,
Mark
Thanks, Mark. I've just edited my post to make it clearer. Essentially my IF formula is not transforming the "Top 25% of my organisation in seniority" response to "Senior role", whilst every other value is transformed as desired.
Any ideas?
Thanks,
KA
Did you try using the top part of my expression?
ELSEIF
Left([field],3) = "Top" THEN "Senior role"
cheers