Forum Discussion
Find the average for different ranges
Hello Everyone, I would like to get the get the average of the %Hch. But to group the %Rej in ranges and have these values to be used. Below shows the dsplay of the data and how I would like to grop...
Anonymous Hello,
I tried this but use the bins to group the data at a range. I also used a meassure to calculate the average of each bin. Is there a way I can use this as a look up?
For example if I have values I would like to look up data from the table above
so if I have 1.80 as %Rej it would show 70.58 %Hch.
Hi sophtee
what is your measure and how you group up the data?
Do you mean that if you choose 1.80(%Rej), the outcome returns the 70.58 whose %Rej(2.69) next and greater than 1.80?
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.