Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate average with filter

Hello everybody, i need to calculate an average but i have to calculate the averagex with the despatch's quantity, for example, in brasil "Suma total de las etapas" = 157, and i have 21 despat...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 

    I don't think AVERAGE function ignores blank rows. However if it does you can divide the SUM over the COUNTROWS of the table

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi， Anonymous 

If your problem has been solved, please accept the reply as solution to close this thread, so that other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason