Trying to figure out a report that shows how much weight is lost

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a fitness app and in that fitness app is a table called weigh in.  Each record contains a weigh in value.

I am trying to make a report that shows how much weight is lost but this seems to be eluding me.  

I run a summary report and I can display two columns that shows the maximum weigh in and the minimum weigh in, but I can't seem to figure out how to display the simple equation... max weigh in minus min weigh in to get the total weight lost.

Any thoughts?  Am I missing something?

Appreciate the help

Mike
Photo of Michael

Michael

  • 20 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,914 Points 50k badge 2x thumb
I assume that you have a relationship where 1 Club member has Many Weigh Ins.  You can make a summary field of the maximum of the weight, and then look that up down to the weigh ins table.  Then do you subtraction of the current weight on the weigh in record from the maximum weight.