AnsweredAssumed Answered

Cannot get Case(Not IsEmpty) script to work

Question asked by danlee on Dec 19, 2014
Latest reply on Dec 20, 2014 by danlee

Title

Cannot get Case(Not IsEmpty) script to work

Post

Right now if the number falls within these ranges, "Very High", "High", etc will appear in c_BodyFat_Word field.  But if there is nothing in c_RecentBodyFat field then I want c_BodyFat_Word field to be blank.  Right now the Not IsEmpty script works but if there is data in c_RecentBodyFat field then the data in c_BodyFat_Word field shows up with a "0" instead of, "Very High", "High", etc.  

Case (not IsEmpty ( c_RecentBodyFat) ; 
Gender = "Male" and c_RecentBodyFat > .21 ; "Very High" ;
           Gender = "Female" and c_RecentBodyFat > .34 ; "Very High" ;
Gender = "Male" and c_RecentBodyFat > .18 and c_RecentBodyFat < .211 ; "High" ;
           Gender = "Female" and c_RecentBodyFat > .29 and c_RecentBodyFat < .341 ; "High";
Gender = "Male" and c_RecentBodyFat > .1 and c_RecentBodyFat < .151 ; "Optimal" ;
           Gender = "Female" and c_RecentBodyFat > .19 and c_RecentBodyFat < .241 ; "Optimal" ;
Gender = "Male" and c_RecentBodyFat > .15 and c_RecentBodyFat < .181 ; "Moderate" ;
           Gender = "Female" and c_RecentBodyFat > .24 and c_RecentBodyFat < .291 ; "Moderate" ;
Gender = "Male" and c_RecentBodyFat > .1 and c_RecentBodyFat < .151 ; "Optimal" ;
           Gender = "Female" and c_RecentBodyFat> .19 and c_RecentBodyFat < .241 ; "Optimal" ;
Gender = "Male" and c_RecentBodyFat < .101 ; "Low" ;
           Gender = "Female" and c_RecentBodyFat < .191 ; "Low" ; "")

Outcomes