Forum Discussion
How to get the average through different table
I already found the solution for this.
Average for Customer Promise =VAR Count_ =INT ( Table 1<> BLANK () )+ INT ( Table 2 <> BLANK () )+ INT ( Table 3 <> BLANK () )RETURNDIVIDE ( Table 1+ Table 2 + Table 3, Count_ )
Hi amitchandak , I've try the method you give but it doesn't work as the table for customer is the combination of my sheet in the field. so when i try it it turn on error. because i dont have one table for all the customer value.
Anonymous , in Values you need to give group by or the not summarized column of visual and that should close by ) like customer
I try to group the measures into one table like the image below but when I insert the the formula for the averagex it still error.
it stated that the group does not have the column why it happen like that?
Anonymous , is the Sum of CP is measure? Also, you can not use values on a table in this case , you need to give a column
yes the sum of cp is the measure where i sum all the 9 percentage in the table so that I can divide by 9 but the disadvantage that happen is it ignore all the blank value as it divide all the value by 9 eventhough there is table that have less than 9 values as there is blank value in it.