Forum Discussion

jgarciac's avatar
jgarciac
Frequent Visitor
7 years ago
Solved

Error in average

Hello, I need help please.... I have a table which has 2 columns, category and quantity, to calculate the average i try out these two methods: ITEM 1 TOTAL 11,252.64 Quantity: 7   Case 1: Ave...
Need Help
  • jgarciac's avatar
    jgarciac
    7 years ago

    After reviewing the total sums, the error was  in the badly used month filter ....Thank you

Arul's avatar
Arul
Super User
7 years ago

Hi jgarciac ,

Use measure to calculate the average 

Formula is,

Measure = SUM(quantity column name])/7

Thanks,

-Arul