Forum Discussion
Weighted average using summarized volume by ID
And what about this?
Hello,
What about this?
Hey avanderschilden,
looking at a line level it worked, but when i looked at the total it did not worked :/
The measure is correct one and the measure 2 is your measure. It is weighted by line, but the total is not working =/
1533,96 / 1068 = 1,4362
Excuse me but I don't understand what you mean.
What is the 1533,96? The total displays a different number; 1824,96.
And you say measure 2 is wrong, but it seems measure 1 is producing the correct result also on the total line.
So what is actually the problem now?
Hey avanderschilden ,
Sorry for not explaining in a right way...
1533,96 is the sum of premium_base in the lines that the premium is not 0...
i need to consider values for the premium base only if the the sum of it by id is different from 0...
The measure 1 works but it is not perfomatic at all.... Your measure (measure 2) works when we look at the lines, but when we look at the total it gives a result considering the whole premium base value...
Do you know another way to make it happens?
And what about this?