# calc not working

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

##### 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"

)

##### Share on other sites

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

##### Share on other sites

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

## Create an account

Register a new account