Page History

dim1Avg = [Average: Dimension 1 Score];
dim2Avg = [Average: Dimension 2 Score];
dim3Avg = [Average: Dimension 3 Score];
dim4Avg = [Average: Dimension 4 Score];
dim5Avg = [Average: Dimension 5 Score];

lowestScore = min(dim1Avg, dim2Avg, dim3Avg, dim4Avg, dim5Avg);

result = if (dim1Avgdim5Avg == lowestScore, "Dimension 15", "Unknown");
result  = if (dim2Avgdim4Avg == lowestScore, "Dimension 24", result);
result    =   if (dim3Avg == lowestScore, "Dimension 3", result);
result           = if (dim4Avgdim2Avg == lowestScore, "Dimension 42", result);
               result = if (dim5Avgdim1Avg == lowestScore, "Dimension 51",                     "Unknown"
                )
            )
        )
    )
)result);