between statement beastmode

Reply
Highlighted
32 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
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
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
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!