Have calculation field that I do not want to count blanks
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.