AnsweredAssumed Answered

trying to set field value according to last value of street number

Question asked by user2148443 on Jan 15, 2019
Latest reply on Jan 15, 2019 by comment

Trying to add a simple calculation to set a fields value depending on the street address number.

Have tried setting it via a case using the right calculation to try and get the last street number value.

 

Using this in the Calculate Field

Case (

Right ( Site Address Number ; 1 ) = "1" ; Watering Days = "Wednesday & Saturday / Monday";

Right ( Site Address Number ; 1 ) = "2" ; Watering Days = "Sunday & Thursday / Tuesday";

Right ( Site Address Number ; 1 ) = "3" ; Watering Days = "Monday & Friday / Wednesday";

Right ( Site Address Number ; 1 ) = "4" ; Watering Days = "Tuesday and Saturday / Thursday";

Right ( Site Address Number ; 1 ) = "5" ; Watering Days = "Sunday & Wednesday / Friday";

Right ( Site Address Number ; 1 ) = "6" ; Watering Days = "Monday & Thursday / Saturday";

Right ( Site Address Number ; 1 ) = "7" ; Watering Days = "Tuesday & Friday / Sunday";

Right ( Site Address Number ; 1 ) = "8" ; Watering Days = "Wednesday & Saturday / Monday";

Right ( Site Address Number ; 1 ) = "9" ; Watering Days = "Sunday & Thursday / Tuesday";

Right ( Site Address Number ; 1 ) = "2" ; Watering Days = "Monday & Friday / Wednesday";

)

 

But i am not getting a result.

Outcomes