Forum Discussion
How to get the average through different table
Hi, I'm sorry for bothering but I really want to ask the question. What to do if I want to get the average score for the below attribute while ignoring the blank value. As I a begginer what I do ...
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_ )
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.