Day of week Beast Mode Code

ozarkram · 2022-05-13T16:22:12+00:00

There was an error rendering this rich post.

Hi All,

I am trying to do the following calculation in Beast mode but I am getting some errors.. Can you please help me with this..

Case when Plant ='Celes' and dayofweek(orderdate) in (2,3,4,5) then '50'

when Plant ='menes' and dayofweek(orderdate) in (2,3,4,5) then '90'

end

Would appreciate your input!

Thanks,

Arun

Find more posts tagged with

Beast Mode

Accepted answers

GrantSmith

Hi @ozarkram

What errors are you receiving?

Have you use back ticks (`) in your beast mode?

Case when `Plant` ='Celes' and dayofweek(`orderdate`) in (2,3,4,5) then '50'

when `Plant` ='menes' and dayofweek(`orderdate`) in (2,3,4,5) then '90'

end

All comments

GrantSmith

Hi @ozarkram

What errors are you receiving?

Have you use back ticks (`) in your beast mode?

Case when `Plant` ='Celes' and dayofweek(`orderdate`) in (2,3,4,5) then '50'

when `Plant` ='menes' and dayofweek(`orderdate`) in (2,3,4,5) then '90'

end

ozarkram

Hi @GrantSmith : Sorry this was a mistake at my end..Happy Friday! and Happy weekend