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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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