Forum Discussion
Solved
SWITCH does not add the third value
Hello all, I have a table of Course dates with columns Order Date, Sales Amount, etc. for purchasing other products before or after a course. I calculated a Date Difference between [Course Date] ...
This is what I see.
the first condition says "give me all results that are zero, and at the same time are less than 90". This will return no result as there is no number that can be both.
the second, third conditions have cross over. Eg -45 satisfies both 2 and 3.
Of course! Thanks for pointing this to me, I need more sleep, haha.