AnsweredAssumed Answered

OnObjectValidate calculation trouble

Question asked by LauraJones on May 19, 2015
Latest reply on May 19, 2015 by SteveMartino

Title

OnObjectValidate calculation trouble

Post

Hi, 

I am trying to create validations for several of my fields and decided to use the OnObjectValidate option. The script seems to work, I use the "If" function to write a calculation with my validations and then if false, the field is cleared and a message appears. All the steps seem to work but only half of the validations within the calculation seem to work correctly. This is the calculation:

Not (Infant Demographics Record Sheet::Mean blood pressure = "[ND]" or IsEmpty (Infant Demographics Record Sheet::Mean blood pressure) or Length ( Infant Demographics Record Sheet::Mean blood pressure )  ≤  2  and ( Filter ( Infant Demographics Record Sheet::Mean blood pressure ; "9876543210" ) ) and Infant Demographics Record Sheet::Mean blood pressure   <  81 and Infant Demographics Record Sheet::Mean blood pressure   >  4)

When the field is empty or says [ND] everything works fine but it will only let me enter values 5-8 and 40-81. Why is there a section of values it won't allow? 

Outcomes