This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi Family,
Why wouldn't this work?
if [SEC Question] = "" or
if [SEC Question] = "None, the entity is neither an SEC registrant /FPI nor a Canadian Reporting Issuer."
then "Non-SEC"
else "SEC"
endif
Solved! Go to Solution.
Hi @AuditPro13
remove the second stated "if" and it should be okay.
to be :-
---------------
if [SEC Question] = "" or
[SEC Question] = "None, the entity is neither an SEC registrant /FPI nor a Canadian Reporting Issuer."
then "Non-SEC"
else "SEC"
endif
---------------
Regards,
Aidan
Thank you bruv!
For some reason its still not working though. Its returning all SEC when there are blanks (or [NULL]) and "None, the entity is neither an SEC registrant /FPI nor a Canadian Reporting Issuer."
Any clue what it could be?
Getting closer!
The blanks are now showing Non-SEC but None, the entity is neither an SEC registrant /FPI nor a Canadian Reporting Issuer. is still showing SEC.
Any ideas?
Thank you again! Hope you have a wonderful weekend Thableaus.