AnsweredAssumed Answered

Conditional if statement:  Null in expression

Question asked by kat_hoenke_fws_col on Jun 14, 2018
Latest reply on Jun 15, 2018 by jborgion

Hi all,

 

I'm trying to get some conditional if statements to work and I'm receiving an error that there is a NULL in the expression:  if(${SARP_SCORE},1,'No Barrier',if((${SARP_SCORE},< 1) and (${SARP_SCORE},>=0.8),'Insignificant Barrier',if((${SARP_SCORE},< 0.8) and (${SARP_SCORE},>=0.6),'Minor Barrier',if((${SARP_SCORE},< 0.6) and (${SARP_SCORE},>=0.4),'Moderate Barrier',if((${SARP_SCORE}, <0.4 ) and (${SARP_SCORE},>=0.2),'Significant Barrier',if((${SARP_SCORE},< 0.2) and (${SARP_SCORE},>=0),'Severe Barrier','Not Scored'))))))

 

Any insight?

 

Thank you!

Outcomes