I have a table where different group clients submit weekly weights on a form.
I'm calculating "starting weight - weekly weight = X". With each submission, I send them an automated email that records what their weight loss is, BUT even though their weekly weight loss differs, I want to only send them the max weight they've lost of all the weeks submitted.
e.g. starting weight - 200lbs
week 1 submission = 194 (6lbs lost)
week 2 submission = 196 (4lbs lost)
week 3 submission = 197 (3lbs lost)
So their record will continue to pull only the "194 (6lbs lost)" until a higher weight loss is submitted.
How do I do that? The rollup fields are not working for me - or am I missing something! The current rollup field is reflecting all 0 but there are no zero entries.
