masshunter reoprt builder IsQualifierResponseRatioNull issue

Question

i run the expression about OutlierQualifierOutOfLimits. 
 but i find QualifierResponseRatio show to empty could cause them problems 
 
 do you have any way can fix the problem.

import System import clr clr.AddReference("System.Drawing") import System.Drawing 
 if BoundItems["QualifierPeak"].IsOutlierQualifierOutOfLimitsNull(): TemplateItems["Cell"].BackgroundColor = System.Drawing.Color.White else: if BoundItems["QualifierPeak"].OutlierQualifierOutOfLimits=="High": TemplateItems["Cell"].BackgroundColor = System.Drawing.Color.Red if BoundItems["QualifierPeak"].OutlierQualifierOutOfLimits=="Low": TemplateItems["Cell"].BackgroundColor = System.Drawing.Color.DeepSkyBlue 
 "" if BoundItems["QualifierPeak"].IsQualifierResponseRatioNull() else BoundItems["QualifierPeak"].QualifierResponseRatio

howard_sanford · Answer

Hello jeremy_lai , 
 In your expressions you must check for both the existence of the qualifier and the outlier yourself. In the initial if and in the final one you need to add a check to see if there is a qualifier by checking to see if it is None. 
 if BoundItems[&ldquo;xxx&rdquo;] is None or BoundItems["xxx"].IsOutlierQualifierOutOfLimitsNull(): 
 Where xxx is the name of your qualifier binding, which in your case appears to be QualifierPeak. 
 The order of checks is important. If you put the null check first it will still fail. Once one part of an if &hellip; or evaluates as true no other conditions are checked.