Message 1 of 4
Boolean Statement w/ Text, Erroring
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi all, been scratching my head on this. Given the parameters below:
What I want is that when DO_Card Reader says "CR", only Red will be checked. And when DO_Card Reader says anything else, only Blue will be checked.
I've used the statement if([DO_Card Reader]="CR", 1=1, 1=0) and other variations, but I keep getting an "Improper use of boolean expressions" error.
A different statement that has no text like "CR" works just fine.
What formula can I put in here to make it work properly?
Reply
Reply