Want to know what’s going on behind the scenes when using LOD fields? This guide will breakdown the differences between how include, fixed and exclude and how they are calculated

Calculated LOD fields:

{Include [Player] : AVG([Score])}

{Fixed [Player] : AVG([Score])}

{Exclude [Player] : AVG([Score])}

# NO DIMENSION

**NoLOD**

When there is no dimension, noLOD will be calculated by averaging the entire score without considering the player.

Calculation: Average(5+6+2+7+10+11+12+6+9)

(5+6+2+7+10+11+12+6+9)/9 = 7.56

**Include**

Average the total score of each player and then average the averages.

Calculation: Average[Average(5+6+2+7+10)+ Average(11+12+6+9)] = 7.75

[(5+6+2+7+10)/5 + (11+12+6+9)/2]/2 = 7.75

**Fixed**

Calculated the same as Include

**Exclude:**

Ignores the Player column – hence, calculated same as noLOD

# PLAYER

**NoLOD**

Average the total score of each player

A Calculation: Average(5+6+2+7+10) = 6.00

(5+6+2+7+10)/5 = 6.00

B Calculation: Average(11+12+6+9) = 9.00

(11+12+6+9)/4 = 9.00

**Include**

Average the total score of each player within each player and then average the averages

A Calculation: Average[Average(5+6+2+7+10)] = 6.00

[(5+6+2+7+10)/5]/1 = 6.00

B Calculation: Average[Average(11+12+6+9)]

[(11+12+6+9)/4]/1 = 9.50

**Fixed**

Average the total score of each player and then take the average of these averages (same calculation as Include in this case)

A Calculation: Average[Average(5+6+2+7+10)]

[(5+6+2+7+10)/5]/1 = 6.00

B Calculation: Average[Average(11+12+6+9)]

[(11+12+6+9)/4]/1 = 9.50

**Exclude**

Ignores the Player column – hence, finds the average of all scores

A Calculation: Average(5+6+2+7+10+11+12+6+9)

(5+6+2+7+10+11+12+6+9)/9 = 7.56

B Calculation: Same as A Calculation.

# TEAM

**NoLOD**

Average the score for each team

AUS Calculation: Average(2+10+11+9)

(2+10+11+9)/4 = 8.00

GBR Calculation: Average(5+6+7+12+6)

(5+6+7+12+6)/5 = 7.20

**Include**

Average the total scores for each player within each team and then average the averages

AUS Calculation: Average[Average(2+10) + Average(11+9)]

[(2+10)/2 + (11+9)/2]/2 = 8.00

GBR Calculation: Average[Average(5+6+7) + Average(12+6)]

[(5+6+7)/3 + (12+6)/2]/2 = 7.50

**Fixed**

Average the total scores for each player (regardless of team) then take the average of this average for each player

AUS Calculation: Average[Average(5+6+2+7+10)+ Average(11+12+6+9)]

[(5+6+2+7+10)/5 + (11+12+6+9)/2]/2 = 7.75

GBR Calculation: Average[Average(5+6+2+7+10)+ Average(11+12+6+9)]

[(5+6+2+7+10)/5 + (11+12+6+9)/2]/2 = 7.75

**Exclude**:

Ignores the Player column – hence, calculated same as noLOD

# YEAR

**NoLoD**

Average the scores for each year

2012 Calculation: Average(5+2+7)

(5+2+7)/3 = 4.67

2013 Calculation: Average(6+10+11+12+6+9)

(6+10+11+12+6+9)/6 = 9.00

**Include**

Average the total scores for each player within each year and then average the averages

2012 Calculation: Average(5+2+7)

(5+2+7)/3 = 4.67

2013 Calculation: Average(Average(6+10) + Average(11+12+6+9))

((6+10)/2 + (11+12+6+9)/4)/2 = 8.75

**Fixed**

Average the total scores for each player (regardless of year) then take the average of this average for each player

2012 Calculation: Average[Average(5+6+2+7+10)]

[(5+6+2+7+10)/5]/1 = 6.00

2013 Calculation: Average[Average(5+6+2+7+10)+ Average(11+12+6+9)]

[(5+6+2+7+10)/5 + (11+12+6+9)/2]/2 = 7.75

**Exclude**

Ignores the Player column – hence, calculated same as noLOD