PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV Mobile 2024
→
To calculate a grand total in a table?
To calculate a grand total in a table?
Started by RobertLEO, Oct., 17 2019 8:26 AM - 6 replies
Connect yourself…
RobertLEO
#1
Registered member
36 messages
Posted on October, 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?
Report
0
0
Jim
#2
Posted on October, 17 2019 - 9:27 PM
There is a SUM function, but it is for arrays.
Stuff your row into an array.
Report
0
0
RobertLEO
#3
Registered member
36 messages
Posted on October, 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)
Report
0
0
Jim
#4
Posted on October, 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
Report
0
0
RobertLEO
#5
Registered member
36 messages
Posted on October, 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
Report
0
0
Jim
#6
Posted on October, 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
Report
0
0
Jim
#7
Posted on October, 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
Report
1
0
→ Go back to WINDEV Mobile 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text