AnsweredAssumed Answered

Setting a field value based on another field value

Question asked by RodSamuel on Feb 26, 2015
Latest reply on Feb 26, 2015 by philmodjunk

Title

Setting a field value based on another field value

Post

I have two fields, the first field value is based on a range of values from the second field. For example the second field may have a value of 0 to 360, and the first field will assign a value of "0" for 0 to 37, "1" for 38 to 111, "2" for 112 to 185, "3" for 186 to 259 and "4" for 260 to 360. Below is an example I have tried but without success.

If ( QUIZ::Reds Score ≤ 360 or QUIZ::Reds Score ≥ 260 ; QUIZ::Reds = 4 ;
If ( QUIZ::Reds Score ≤ 259 or QUIZ::Reds Score ≥ 186 ; QUIZ::Reds = 3 ;
If ( QUIZ::Reds Score ≤ 185 or QUIZ::Reds Score ≥ 112 ; QUIZ::Reds = 2 ;
If ( QUIZ::Reds Score ≤ 111 or QUIZ::Reds Score ≥ 38 ; QUIZ::Reds = 1 ;
If ( QUIZ::Reds Score ≤ 37 or QUIZ::Reds Score ≥ 0 ; QUIZ::Reds = 0 ; 0)))))

Any suggestions, thanks inadvance

Outcomes