faaslave Posted September 14, 2006 Share Posted September 14, 2006 I have this calc Case ( Sup Crew = "1" or "8" or "15" or "22" or "29" or "36"; "Sat/Sun"; Sup Crew = "2" or "9" or "16" or "23" or "30" or "37"; "Sun/Mon"; Sup Crew = "3" or "10" or "17" or "24" or "31" or "38" ; "Mon/Tue"; Sup Crew = "4" or "11" or "18" or "25" or "32" or "39"; "Tue/Wed"; Sup Crew = "5" or "12" or "19" or "26" or "33" or "40"; "Wed/Thu"; Sup Crew = "6" or "13" or "20" or "27" or "34" or "41"; "Thu/Fri"; Sup Crew = "7" or "14" or "21" or "28" or "35" or "42"; "Fri/Sat"; "unknown" ) No matter what number is in the field (Sup Crew), the result comes out "Sat/Sun" I don't get it, it should work. Thanks Dave Link to comment Share on other sites More sharing options...
Raybaudi Posted September 14, 2006 Share Posted September 14, 2006 Hi you can't write a multi-condition so: Sup Crew = "1" or "8" or "15" or "22" or "29" or "36" but eventually so: Sup Crew = "1" or Sup Crew = "8" or Sup Crew = "15" or Sup Crew = "22" or Sup Crew = "29" or Sup Crew = "36" This type of calc can be solved by a simple Choose (), so try this: Choose ( Mod (Sup Crew ; 7 ); "Fri/Sat"; "Sat/Sun"; "Sun/Mon"; "Mon/Tue"; "Tue/Wed"; "Wed/Thu"; "Thu/Fri" ) Link to comment Share on other sites More sharing options...
faaslave Posted September 14, 2006 Author Share Posted September 14, 2006 Works Great, and I see why mine didn't work now. That is quite a calc. So the mod does some kind of division, with 7 being the divisor? Very tricky, but excellent for what I need. Thanks a bunch, Dave Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6576 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now