I'm trying to build a formula in saved search usin...
# administration
m
I'm trying to build a formula in saved search using the {posting} field. I can't seem to make it work inside a case statement. I've tried using it as a standalone boolean variable like "...AND {posting}...", compared it to an integer "... AND {posting}>0...", and compared it to a string "...AND {posting} = 'Yes'...". It did not work for these cases I've tested. Anyone tried using the {posting} field inside a case statement?
a
I believe the Posting is a True/False parameter. Try CASE WHEN {posting} = ‘T’
1
m
I think you're right. It's working now. THANKS!