Forum Discussion

atziovara's avatar
atziovara
Icon for Helper I rankHelper I
2 years ago
Solved

Weighted Average with double filter Issue

I want to compute the Weighted Average for one of the following Questions, based on the value of the Answer to another Question. For example, I would like to compute the Weighted Average of the Liqu...
Need Help
  • some_bih's avatar
    some_bih
    2 years ago

    Hi atziovara Please check enclosed file two different tabs for two scenarios.

    I created 6 different measures just for debug (it could be less number of measures).

    Results are as in your example

    Part 1 ratio = 0,50 and Part 2 ratio = -0,3276

    Picture below for Part 2.

     

some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi atziovara Please check enclosed file two different tabs for two scenarios.

I created 6 different measures just for debug (it could be less number of measures).

Results are as in your example

Part 1 ratio = 0,50 and Part 2 ratio = -0,3276

Picture below for Part 2.