Forum Discussion
Solved
Weighted average using summarized volume by ID
Hey guys, i have a question about how to do calculate a different weighted average... Basically i have more than one line by slip, and i need to use the summarized value by slip to use in this avera...
And what about this?
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!