Hi,
I'm new to domo and struggling a bit on what seem fairly simple issues so apologies if this is a stupid question.
I am using a Case statement in Beast mode to try and return the number 1 if certain criteria are met. I've managed to return the number 1 as text so far but need to return it as a number rather than text. When I remove the quote marks from around the 1s it gives me a syntax error.
CASE
When `Stage` = 'Cancelled' THEN 1
When `Stage` = 'Rejected' THEN 1
When `Stage` = 'Not Interested' THEN 1
When `Stage` = 'Invited to Apply' THEN 1
Else ''
end
Thanks!