4 Replies Latest reply on Nov 20, 2016 10:26 PM by Johan De Groot

# Help with LOD?

Hi all.

I have data of people who participated in 4 races: 2 in North America, 2 in Europe.

It is all in one master spreadsheet.

I would like to identify who has participated in at least one race in each continent.

Can anyone shed some light?

Workbook attached

Thanks

• ###### 1. Re: Help with LOD?

To begin you don't have a field called continent. I'm not sure that the calculated field 'North Am or Europe' gives you the right answer.

Check the workbook i posted.

• ###### 2. Re: Help with LOD?

Hi Patricia,

I think this formula (which results in a boolean true/false) will help you out:

{fixed [Name]: countd([North Am or Europe])} = {countd([North Am or Europe])}

Explanation:

{fixed [Name]: countd([North Am or Europe])}

calculates the number of continents each name has participated a race in

If this is equal to the total number of continents ( {countd([North Am or Europe])}) this name has participated in all continents

Is this what you are looking for?

Kind regards,

Johan de Groot

2 of 2 people found this helpful
• ###### 3. Re: Help with LOD?

Thank you. This is exactly what I needed.