Hi Liliya! I'm not exactly sure what's causing this issue, but you might be able to fix it by switching to CASE...WHEN instead of a bunch of ELSEIFs.
CASE [Business group]
WHEN 'Ultrasound' then 'Grant, Bruce'
WHEN 'HS Informatics, Solutions & Services' then 'Vriesema, Gwen'
WHEN 'Patient Care & Monitoring Solutions' then 'Laurino, Paul'
WHEN 'Sleep & Respiratory Care' then 'Mitchell, Sheila'
WHEN 'Image Guided Therapy' then 'Bowden, Christine'
WHEN 'Diagnostic Imaging' then 'Morales Olivera, Fernando'
WHEN 'Service' then 'Leblanc, Lynne'
WHEN 'Remaining TV' then 'Leblanc, Lynne'
WHEN 'Licenses' then 'Leblanc, Lynne'
WHEN 'Lifestyle Entertainment' then 'Leblanc, Lynne'
WHEN 'TV' then 'Leblanc, Lynne'
WHEN 'Domestic Appliances' then 'Zhou, Ruby'
WHEN 'Personal Care' then 'Hos, Aniek'
WHEN 'Health & Wellness' then 'Hesen, Geerte'
WHEN 'Coffee' then 'Hesen, Geerte'Else 'Guest'
EDIT: Now that I look at it closer, you might have some of Word's fancy quotation marks instead of the basic ones Tableau uses in there. I'm not sure if that caused the issue, but it might. Next time, I'd recommend using Tableau's built-in editor instead of Word to build your formula.
Thank you for the response but the issue is that 'Leblanc Lynn' is responsible for several Business groups. I use this formula to control user access so when Lynn logs in she can only see business groups she is responsible for. I had when formula but it did not work, resulted in Blank result on the dashboard and i know it should not be. I included the view shot as an attachment. Thank you.
Lynn leblanc.docx 363.4 KB
Hi Liliya, it seems like manual user filters would be a lot easier to implement here. Have you looked at this? User Filters and Row Level Security | Tableau Software
Also, note that you can paste images directly from your clipboard into this forum's reply/edit window. You don't need to save them into a Word document.
ok, thank you, i will look into this.