PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español FR
Inicio → WINDEV Mobile 2024 → To calculate a grand total in a table?
To calculate a grand total in a table?
Iniciado por RobertLEO, 17,oct. 2019 08:26 - 6 respuestas
#1
Miembro registrado
36 mensajes
Publicado el 17,octubre 2019 - 08:26
Hello, I need your help, I have a table with numeric values across the columns and I need to create a row that sums up the grand total like how an excel's SUM(Columnstart:Columnend) would, is this possible in Windev Mobile for Android and iOS, and how to do this?
#2
Publicado el 17,octubre 2019 - 21:27
There is a SUM function, but it is for arrays.
Stuff your row into an array.
#3
Miembro registrado
36 mensajes
Publicado el 18,octubre 2019 - 11:57
Jim wrote:
There is a SUM function, but it is for arrays.
Stuff your row into an array.


would this method be applicable if the table rows are not fixed? (as in there will be a lot of entries and more will be added as the usage goes on)
#4
Publicado el 18,octubre 2019 - 18:25
It is doable, you just have to make sure your array matches the table row(s) all the time.
Then recalculate anytime there is a change.

Jim
#5
Miembro registrado
36 mensajes
Publicado el 21,octubre 2019 - 05:17
Jim wrote:
It is doable, you just have to make sure your array matches the table row(s) all the time.
Then recalculate anytime there is a change.

Jim



sweet, is this doable with columns instead as the sequence of numbers are on the columns B and beyond, while A is for what the row is for
#6
Publicado el 21,octubre 2019 - 16:09
Robert,

That will be a little harder.
I can't see an easy way of doing it by columns.

Jim
#7
Publicado el 21,octubre 2019 - 16:11
The following code was adding the rows.
temparray is array of int

ResRandom is int
ResRandom2 is int
ResRandom3 is int

TableDeleteAll(Table1)
ArrayDeleteAll(temparray)


ResRandom = Random(33)
ResRandom2 = Random(25)
ResRandom3 = Random(100)
TableAddLine(Table1,ResRandom,ResRandom2,ResRandom3)
AddLine(temparray,ResRandom)
AddLine(temparray,ResRandom2)
AddLine(temparray,ResRandom3)

Table1.Sum = Sum(temparray)


Jim
→ Volver a WINDEV Mobile 2024