Record high BMI displays record low BMI

Bug #868296 reported by Julien
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Weight Tracker ODS
Fix Released
High
Jon Thysell

Bug Description

In sheet Main, the Record High BMI actually shows the same thing as the Record Low BMI.
This is because the formula in cell B398 (Highbmi) of hidden sheet Total is a copy/paste of that in cell B397 (lowbmi). In B398, all references to lowweight should be replaced by references to highweights, as follows:

=IF(AND(ISNUMBER(highweight),ISNUMBER(height)),IF(ISERROR(IF(metric,1,703)*highweight/((IF(metric,0.01,1)*height)^2)),"",IF(metric,1,703)*highweight/((IF(metric,0.01,1)*height)^2)),"")

Thanks for the great work, very useful!

Related branches

Jon Thysell (jonthysell)
Changed in wtods:
status: New → Confirmed
importance: Undecided → High
assignee: nobody → Jon Thysell (jonthysell)
milestone: none → 2.2.3
status: Confirmed → Triaged
Jon Thysell (jonthysell)
Changed in wtods:
status: Triaged → Fix Committed
Jon Thysell (jonthysell)
Changed in wtods:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.