Error in SUM

[Soporte_Gestion]

Hello!
I create 2 virtual columns so I can SUM the total amount of Rows in a table.
Virtual column 1: COUNT(LIST(Data[UID]))
Virtual column 1:SUM(Data[Virtual column 1])
And I don´t know why is not summing the correct amount of rows, the table in the spredsheet has 1018 rows and the SUM bring me 999.

[LeventK]

Why do you need to count the sheet rows? If you need to get the last row in the table then

MAX(TableName[_RowNumber])

will suffice actually. Provided your aim is to count the number of rows which contains data (not blank), then your expression is not correct at all.

[Soporte_Gestion]

I need to have an average of a SUM of all durations from a column, so as each row have there own duration, my client needs to know the SUM of all durations and average.
So for that I need to devide total duration over total Rows

[Marc_Dillon]

help.appsheet.com

AVERAGE()

Arithmetic average of list items

[Steve · Accepted solution]

Soporte_GestionApp:

Virtual column 1: COUNT(LIST(Data[UID]))

Should be:

COUNT(Data[_ROWNUMBER])

[Soporte_Gestion]

I try this all ready and is giving me 999 insted of the total rows in the table.
Just try and save and is working , where is not working is when you click on the TEST link from the expression box, that is given the 999 insted of the total Rows

[Steve]

The Test feature only works with the first 1000 rows by default.

[Soporte_Gestion]

I change it to 5000 and still show 999

[Steve]

Please contact support@appsheet.com for help with this.