Pulling Max Value

Topic Labels: Formulas
285 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1

Hmm, are you using "MAX" and "MIN" for your rollups? 

Screenshot 2024-02-24 at 9.05.19 PM.png

Screenshot 2024-02-24 at 9.05.04 PM.png

Link to base