if statement

AuditPro13

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

Datasets

Accepted answers

Thableaus

Try

if IsEmpty(Trim([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

Thableaus

The string is too long and probably there's a character mismatch.

I'd advise you to use keywords on this string and the function Contains instead of matching the full string.

Contains(SEC Question, "None"), for example

All comments

Thableaus

There's an extra If in your statement

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

Cheers,

Aidan_K

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

AuditPro13

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703