Hi,
i am wondeirng if somone can help me i have a list of values which need to be rolled up from Level 1 to level 2 to level 3
e.g.
| Level 3 | | Level 2 | | Level 1 | Score |
| 1 | 4.48 | 1.1 | 4.77 | 1.1.1 | 4.83 |
| 1.1.2 | 4.67 |
| 1.1.3 | 4.67 |
| 1.1.4 | 5.00 |
| 1.1.5 | 4.67 |
| 1.2 | 4.33 | 1.2.1 | 4.83 |
| 1.2.2 | 4.17 |
| 1.2.3 | 4.00 |
| 1.2.4 | 4.33 |
| 1.2.5 | 4.33 |
| 1.3 | 4.33 | 1.3.1 | 4.17 |
| 1.3.2 | 4.33 |
| 1.3.3 | 4.50 |
| 2 | 4.47 | 2.1 | 4.63 | 2.1.1 | 4.67 |
| 2.1.2 | 4.67 |
| 2.1.3 | 4.83 |
| 2.1.4 | 4.33 |
| 2.1.5 | 4.67 |
| 2.2 | 4.72 | 2.2.1 | 4.67 |
| 2.2.2 | 4.67 |
| 2.2.3 | 4.83 |
| 2.3 | 5.22 | 2.3.1 | 5.00 |
| 2.3.2 | 5.50 |
| 2.3.3 | 5.17 |
| 2.4 | 4.39 | 2.4.1 | 4.00 |
| 2.4.2 | 4.50 |
| 2.4.3 | 4.67 |
| 2.5 | 4.40 | 2.5.1 | 4.40 |
| 2.5.2 | 4.20 |
| 2.5.3 | 4.60 |
| 2.6 | 4.53 | 2.6.1 | 4.20 |
| 2.6.2 | 4.80 |
| 2.6.3 | 4.60 |
| 2.7 | 3.87 | 2.7.1 | 3.80 |
| 2.7.2 | 3.80 |
| 2.7.3 | 4.00 |
| 2.8 | 4.00 | 2.8.1 | 4.00 |
| 2.8.2 | 4.00 |
| 2.8.3 | 3.80 |
| 2.8.4 | 4.20 |
| 3 | 3.76 | 3.1 | 4.15 | 3.1.1 | 4.06 |
| 3.1.2 | 4.13 |
| 3.1.3 | 4.25 |
| 3.2 | 3.80 | 3.2.1 | 3.69 |
| 3.2.2 | 3.38 |
| 3.2.3 | 4.50 |
| 3.2.4 | 3.63 |
| 3.3 | 3.52 | 3.3.1 | 3.50 |
| 3.3.2 | 3.88 |
| 3.3.3 | 3.19 |
| 3.4 | 3.56 | 3.4.1 | 3.25 |
| 3.4.2 | 3.50 |
| 3.4.3 | 3.94 |
| 3.4.4 | 3.56 |
| 4 | 4.05 | 4.1 | 3.89 | 4.1.1 | 4.00 |
| 4.1.2 | 3.93 |
| 4.1.3 | 3.93 |
| 4.1.4 | 3.80 |
| 4.1.5 | 3.80 |
| 4.2 | 3.78 | 4.2.1 | 3.67 |
| 4.2.2 | 3.87 |
| 4.2.3 | 3.80 |
| 4.3 | 4.47 | 4.3.1 | 4.67 |
| 4.3.2 | 4.27 |
| 5 | 4.63 | 5.1 | 4.72 | 5.1.1 | 4.83 |
| 5.1.2 | 4.83 |
| 5.1.3 | 4.67 |
| 5.1.4 | 4.56 |
| 5.2 | 4.70 | 5.2.1 | 4.56 |
| 5.2.2 | 5.00 |
| 5.2.3 | 4.56 |
| 5.3 | 4.53 | 5.3.1 | 4.78 |
| 5.3.2 | 4.28 |
| 5.4 | 4.57 | 5.4.1 | 4.67 |
| 5.4.2 | 4.72 |
| 5.4.3 | 4.33 |
| 6 | 4.21 | 6.1 | 4.72 | 6.1.1 | 5.06 |
| 6.1.2 | 4.67 |
| 6.1.3 | 4.61 |
| 6.1.4 | 4.56 |
| 6.2 | 4.77 | 6.2.1 | 4.89 |
| 6.2.2 | 4.83 |
| 6.2.3 | 4.94 |
| 6.2.4 | 4.50 |
| 6.2.5 | 4.67 |
| 6.3 | 4.15 | 6.3.1 | 4.22 |
| 6.3.2 | 4.28 |
| 6.3.3 | 3.56 |
| 6.3.4 | 4.56 |
| 6.4 | 3.89 | 6.4.1 | 4.11 |
| 6.4.2 | 3.67 |
| 6.5 | 4.37 | 6.5.1 | 5.06 |
| 6.5.2 | 4.33 |
| 6.5.3 | 3.72 |
| 6.6 | 3.37 | 6.6.1 | 3.39 |
| 6.6.2 | 3.50 |
| 6.6.3 | 3.22 |
| 7 | 4.16 | 7.1 | 3.84 | 7.1.1 | 3.93 |
| 7.1.2 | 3.93 |
| 7.1.3 | 3.67 |
| 7.2 | 3.76 | 7.2.1 | 4.20 |
| 7.2.2 | 3.87 |
| 7.2.3 | 3.20 |
| 7.3 | 4.87 | 7.3.1 | 4.80 |
| 7.3.2 | 4.87 |
| 7.3.3 | 4.93 |
| 8 | 4.18 | 8.1 | 4.61 | 8.1.1 | 4.00 |
| 8.1.2 | 3.67 |
| 8.1.3 | 5.00 |
| 8.1.4 | 5.00 |
| 8.1.5 | 5.00 |
| 8.1.6 | 5.00 |
| 8.2 | 3.83 | 8.2.1 | 4.00 |
| 8.2.2 | 3.33 |
| 8.2.3 | 5.00 |
| 8.2.4 | 3.00 |
| 8.3 | 4.67 | 8.3.1 | 4.67 |
| 8.3.2 | 4.33 |
| 8.3.3 | 4.67 |
| 8.3.4 | 5.00 |
| 8.4 | 4.33 | 8.4.1 | 4.67 |
| 8.4.2 | 4.00 |
| 8.5 | 4.27 | 8.5.1 | 4.33 |
| 8.5.2 | 5.33 |
| 8.5.3 | 4.67 |
| 8.5.4 | 4.00 |
| 8.5.5 | 3.00 |
| 8.6 | 4.00 | 8.6.1 | 5.33 |
| 8.6.2 | 3.00 |
| 8.6.3 | 5.33 |
| 8.6.4 | 3.33 |
| 8.6.5 | 3.00 |
| 8.7 | 3.58 | 8.7.1 | 3.00 |
| 8.7.2 | 3.33 |
| 8.7.3 | 4.33 |
| 8.7.4 | 3.67 |
So at level 1 the average is 4.27, then if you average level 2 its 4.26 and then again at level 3 its 4.24
I need some way of being able to do this roll up on the figure for the next level which should be calcuted on the previous level (rather than it using level 1 scores all the time to calcuate) - the issue is mainly arising on an indivdual level 3. Yes i understnd this is a rounding issue so is there something blatently obvious i am ignoring which could be a quick solution?
TIA
