6 Replies Latest reply: Nov 3, 2017 10:27 AM by William Fu RSS

    Weighted average measure not changing based on dimension

    William Fu

      I have this weighted average formula, and it gives me the same values for whichever dimension I pivot it by:


      Sum({$<[LLR.PdCorrente]-={100}>} Total [LLR.PdCorrente] * Aggr (Sum({$<[LLR.PdCorrente]-={100}>} Saldo), [LLR.PdCorrente])) / Sum({$<[LLR.PdCorrente]-={100}>} Total Aggr(Sum({$<[LLR.PdCorrente]-={100}>} Saldo), [LLR.PdCorrente]))


      However if I select a specific member of a dimension, it calculates correctly.


      Any ideas?