B4J Question SOLVED B4XTable How to get the sum of all values in a column

[Yafuhenk]

Does anyone know how I can get the sum of all values in a B4XTable column, so not only the ones that are visible?
Thanks

 

[Erel]

Dim total As Double = B4XTable1.sql1.ExecQuerySingleResult($"SELECT sum(${numberColumn.SQLID}) FROM data"$)
 Log(total)