6 Replies Latest reply on Dec 6, 2018 8:23 AM by Ciara Brennan

# Weightlifting Totals - Sum Max values based on Yes/No condition

Hi everyone, first time posting here! I'm trying to do an analysis of Olympic Weightlifting competition totals and am struggling with creating the calculation.

I'm trying to calculate a person's "Total" for each competition event. This is the sum of the highest successful lifts for two movements, each of which they get 3 attempts at (the Snatch and the Clean & ****).

So essentially, I need to write something that considers if each attempt was a "good lift" (yes or no), and then add the highest "good lifts" for each of the 2 movements.

I've attached the excel data I'm working with so far and below is a single example.

For instance, here I need a calculation that will add Snatch attempt # 2 (77) and Clean & **** attempt # 1 (95) for a "Total" of 172 based on those being the highest "good lifts" for each movement.

Movement      Attempt #      Weight (kg)      Good Lift

Snatch                1                     74                    y

Snatch                2                     77                    y

Snatch                3                     80                    n

Clean & ****      1                     95                     y

Clean & ****      2                     100                   n

Clean & ****      3                     101                   n

Thanks!

Blake

• ###### 1. Re: Weightlifting Totals - Sum Max values based on Yes/No condition

see the attached

create a set as shown

place on filter shelf and set like this

and the formula is

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: Weightlifting Totals - Sum Max values based on Yes/No condition

Hi Jim! This is getting me very close but not quite as far as I need. Is there a way to now get the sum of the highest good lifts for each movement?

I.e. for these three events I'm trying to get to totals of 172 (95+77), 194 (107+87), and 166 (90+76)

I tried experimenting with a few things and nothing worked. Using the automated subtotals under Analysis just returned the highest number between the two lifts. I also tried making separate calculated fields for "Best Snatch" and "Best Clean & ****", and a third "Competition Total" calculated field to add the two, but this third field returned all Nulls.

Attached is my .twbx file if that helps.

Thanks for you help!

Blake

• ###### 3. Re: Weightlifting Totals - Sum Max values based on Yes/No condition

see the attached - ref tab

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 4. Re: Weightlifting Totals - Sum Max values based on Yes/No condition

Hi Blake, just checking if this is now resolved?

Thanks, Ciara

• ###### 5. Re: Weightlifting Totals - Sum Max values based on Yes/No condition

Hi Ciara, yes i'ts resolved. Thanks!

• ###### 6. Re: Weightlifting Totals - Sum Max values based on Yes/No condition

Ah perfect, thanks for letting us know, Blake