This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Yes / No Return for a 1, 0, or null

Posted on 08-06-2021 05:38 AM
jem102166
New Member
Reply posted on --/--/---- --:-- AM

I have a column that has a 1, 0 or is null. I want to display YES for 1 and NO for 0 or null. Please let me know if anyone has any ideas. Thanks!

Solved Solved
0 3 464
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

Maybe this

SWITCH([Column Name], 1, โ€œYesโ€, 0, โ€œNoโ€, โ€œNoโ€)

View solution in original post

Jump to Solution
3 REPLIES 3
Top Labels in this Space