Forum Discussion

New Member

4 years ago

Solved

calculate based on hours

How I can calculate based on hours.. for example all the sales of Friday after 10pm should be count as Monday sales

4 years ago

koralillis Something like this. i think that's what you are asking for?

SWITCH(
  TRUE(),
  Day IN {"Saturday", "Sunday"}, "Monday",
  Day = "Friday" && HourOfDay >= 22, "Monday",
  Day = "Sunday", "Monday",
  "WorkWeek")

Continued Contributor

4 years ago

Could you please share your data table with sample data?

Thank you.