between statement beastmode

Reply
Highlighted
Yellow Belt
Yellow Belt

between statement beastmode

I have a range of delivery values from 1-13. i want to make a beast mode field that returns 1 if delivery value = 5, 6, 7, 8, or 9. If not it returns 0. I tried this statement but it is invalid

 

(CASE when `UAT Job Orders-DeliveryTypeId` (BETWEEN 4 AND 10) THEN 1 ELSE 0 end)

 

Thank you


Accepted Solutions
Highlighted
Major Brown Belt

Re: between statement beastmode

I don't think Domo has a BETWEEN function. You'll have to do something like this in your beast mode:

 

(CASE when `UAT Job Orders-DeliveryTypeId` in (5, 6, 7, 8, 9) THEN 1 ELSE 0 end)

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'

View solution in original post


All Replies
Highlighted
Major Brown Belt

Re: between statement beastmode

I don't think Domo has a BETWEEN function. You'll have to do something like this in your beast mode:

 

(CASE when `UAT Job Orders-DeliveryTypeId` in (5, 6, 7, 8, 9) THEN 1 ELSE 0 end)

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'

View solution in original post

Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.