|
| To calculate a grand total in a table? |
| Iniciado por RobertLEO, out., 17 2019 8:26 AM - 6 respostas |
| |
| | | |
|
| |
Membro registado
36 mensagems |
|
| Publicado em outubro, 17 2019 - 8:26 AM |
| 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? |
| |
| |
| | | |
|
| | |
| |
| Publicado em outubro, 17 2019 - 9:27 PM |
There is a SUM function, but it is for arrays.
Stuff your row into an array. |
| |
| |
| | | |
|
| | |
| |
Membro registado
36 mensagems |
|
| Publicado em outubro, 18 2019 - 11:57 AM |
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) |
| |
| |
| | | |
|
| | |
| |
| Publicado em outubro, 18 2019 - 6:25 PM |
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 |
| |
| |
| | | |
|
| | |
| |
Membro registado
36 mensagems |
|
| Publicado em outubro, 21 2019 - 5:17 AM |
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 |
| |
| |
| | | |
|
| | |
| |
| Publicado em outubro, 21 2019 - 4:09 PM |
Robert,
That will be a little harder.
I can't see an easy way of doing it by columns.
Jim |
| |
| |
| | | |
|
| | |
| |
| Publicado em outubro, 21 2019 - 4:11 PM |
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 |
| |
| |
| | | |
|
| | | | |
| | |
|