Forum Discussion
Weighted average using summarized volume by ID
And what about this?
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?
It Works!!!
Thank you man!