Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average

Good day!   Please help!   How to calculate the average of % from 4 different tables??  Table 1 - KPI 1 - 100% Table 2 - KPI 2 - 100% Table 3 - KPI 3 - 100% Table 4 - KPI 4 - 78%   In the E...
Need Help
  • LuisM1's avatar
    LuisM1
    3 years ago

    Average Percentage = (SUM('Table 1'[KPI 1]) + SUM('Table 2'[KPI 2]) + SUM('Table 3'[KPI 3]) + SUM('Table 4'[KPI 4])) / 4

LuisM1's avatar
LuisM1
Frequent Visitor
3 years ago

Average Percentage = (SUM('Table 1'[KPI 1]) + SUM('Table 2'[KPI 2]) + SUM('Table 3'[KPI 3]) + SUM('Table 4'[KPI 4])) / 4