And what formula is that? I can see that it is not a simple sum, or treating the blanks as zero wouldn't be an issue, but we'd need to see that formula to be able to suggest an alternative that drops out/ignores empty fields.
All I use is sum:
c_Total Inches: "Sum ( MeasurementsData::LeftArm; MeasurementsData::LeftThigh; MeasurementsData::RightArm; MeasurementsData::RightThigh; MeasurementsData::Waist; MeasurementsData::Hips; MeasurementsData::Chest )"
TotalInchesLoss: "c_TotalInchesRecent - MeasurementsData::c_TotalInches"
Then treating a blank as zero should not affect the result.
a + b + c = a + b + c + 0
So I don't see how you can "ignore" the blanks and get a different sum.
Date #1 I have all the fields add up ato 7
Date #2 adds up to 11
Date #3 adds up to 2
I get a -5 for sum
If I upload the file would you mind taking a quick look?
That isn't a sum as there is no way that a sum can produce a negative number from measurements that are blank, zero or greater than zero. 7 + 11 + 2 = 20, not -5.
I think simply posting the actual calcualtion is all that you need to do. And it would appear that you are recording data on multiple dates. Do you record this data in different records, one for each date or do you record the data for multiple dates all in different fields of the same record?
I am recording data on multiple dates. All in diffrent fields of the same record. So each date can possibly have different numbers for their respective fields if there has been an increase or decrease in inches.
I see what it is doing. It is taking my total inches recent minus total inches from very first date. So it is not taking account for any of the other data in between. I think I know how to fix it to what I am wanting.
I would recommend that you set up a related table with one record for the measurements for each date. That almost always makes for a much more flexible way to handle this type of data.