Jump to content

calc not working


faaslave

This topic is 6463 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 6463 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.