AnsweredAssumed Answered

Have calculation field that I do not want to count blanks

Question asked by danlee on Aug 11, 2013
Latest reply on Aug 12, 2013 by philmodjunk

Title

Have calculation field that I do not want to count blanks

Post

     I have a calculation field that has formula:

     c_TotalInchesRecent  - MeasurementsData::c_TotalInches

     It is taking data from 5 fields, "Arm", "Hips", "Chest", "Leg", "Waist"

     Right now if there is if I say put in a 2 for "Arm" and leave the rest blank the calculation assumes that the other 4 fields are 0 and calculates those into the formula.  I want it if there is a blank in any one of those fields it will not take them into account for the calculation formula.

Outcomes