8 Replies Latest reply on Aug 12, 2013 10:15 AM by philmodjunk

    Have calculation field that I do not want to count blanks

    danlee

      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.