Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Pulling Max Value

Topic Labels: Formulas
762 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AndreavS
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