Hi guys. Not sure how to do some calculations for a form I have.
I have 10 objectives per site, and each objective a different number of measures. For example, Objective 1 has 2 measures, Objective 2 has 6 measures etc. Each measure has a weighted score (which is measure score x measure weight) and a maximum weighted score (which is measure weight x 5). These are unbound fields and work fine.
CALCULATION 1: I need to calculate the objective weighted score for that site, which is the sum of all the weighted scores / the sum of all the max weighted scores and x by 100 (to get a percentage) for each objective. As each objective has a different number of measures (and scores) I don't know how to put it.
For example - Objective 1
Measure 1.1
measure weighted score = 15
maximum weighted score = 25
Measure 1.2
measure weighted score = 6
maximum weighted score = 15
Objective 2
Measure 2.1
measure weighted score = 12
maximum weighted score = 30
Measure 2.2
measure weighted score = 9
maximum weighted score = 15 etc.
This would make the objective weighted score for objective 1 to be 52.5% and objective 2 to be 46.67%.
CALCULATION 2: After this, I need to calculate the overall objective scores for that site. This means having a calculation that sums each objective weighted scores and divides them by 10 (to get a overall percentage).
I am very much hoping someone can help me as I am now under a deadline
Thank you for reading the thread though.
I have 10 objectives per site, and each objective a different number of measures. For example, Objective 1 has 2 measures, Objective 2 has 6 measures etc. Each measure has a weighted score (which is measure score x measure weight) and a maximum weighted score (which is measure weight x 5). These are unbound fields and work fine.
CALCULATION 1: I need to calculate the objective weighted score for that site, which is the sum of all the weighted scores / the sum of all the max weighted scores and x by 100 (to get a percentage) for each objective. As each objective has a different number of measures (and scores) I don't know how to put it.
For example - Objective 1
Measure 1.1
measure weighted score = 15
maximum weighted score = 25
Measure 1.2
measure weighted score = 6
maximum weighted score = 15
Objective 2
Measure 2.1
measure weighted score = 12
maximum weighted score = 30
Measure 2.2
measure weighted score = 9
maximum weighted score = 15 etc.
This would make the objective weighted score for objective 1 to be 52.5% and objective 2 to be 46.67%.
CALCULATION 2: After this, I need to calculate the overall objective scores for that site. This means having a calculation that sums each objective weighted scores and divides them by 10 (to get a overall percentage).
I am very much hoping someone can help me as I am now under a deadline
Thank you for reading the thread though.
