Hello!
I try to do a weighted average of data in a single column.
Example:
<tbody>
</tbody>
Simply put, I need to do weighted average per Type for Indicator 2 using Indicator 1.
The Module condition is required as same indicator-type may be in different modules but different unit of measures. so, the consolidation is done per module.
I listed only the conditional columns. The set of modules-indicators-types-data is repeated multiple time for each Location in scope! Therefore this consolidation will show overall result.
Looking forward for the saving net I thank you in advance and I wish you a great day,
Dragos
I try to do a weighted average of data in a single column.
Example:
Module | Indicator | Type | Data |
M1 | Ind 1 | A | 100 |
M1 | Ind 1 | B | 80 |
M1 | Ind 2 | A | 15 |
M1 | Ind 2 | B | 20 |
Mn | Ind n | X |
<tbody>
</tbody>
Simply put, I need to do weighted average per Type for Indicator 2 using Indicator 1.
The Module condition is required as same indicator-type may be in different modules but different unit of measures. so, the consolidation is done per module.
I listed only the conditional columns. The set of modules-indicators-types-data is repeated multiple time for each Location in scope! Therefore this consolidation will show overall result.
Looking forward for the saving net I thank you in advance and I wish you a great day,
Dragos