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_ )
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 () )
RETURN
DIVIDE ( Table 1+ Table 2 + Table 3, Count_ )