Hi There -
Very simple question but I am blanking on the proper syntax. I'm looking to bucket the stragglers that don't fall within this formula as "Other"
Current Formula:
IFNULL([Team Leader],[Team Captain])
What I'm trying to accomplish (but it's clearly wrong):
IFNULL([Team Leader],[Team Captain]) ELSE "Other" END
Any help would be greatly appreciated.
2 answers
@Nestle Mitchell
Hi, in this case you may use:
IFNULL([Team Leader],IFNULL([Team Captain],"Other"))
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
