Page 1 of 1
Calculated fields
Posted: 2018-06-04 12:26
by pasbonte
Hello
I have a table with a field "number of people", can we in a table do the total?
How to put it in my table?
thank you
Re: Calculated fields
Posted: 2018-06-04 13:48
by pbottcher
Hi,
can you be a little bit more specific on how you want to do this. You have a table with field "number of people". So do you want to have the sum of this field in another table?
Re: Calculated fields
Posted: 2018-06-04 14:40
by pasbonte
Yes I have a field with the number of people, and I want to have the total in the same table (the same table).
MERCI !
Re: Calculated fields
Posted: 2018-06-04 16:51
by pbottcher
Hi,
sorry, I still do not get it.
You have a TABLE:
| ID | TEXT | Number of people | Total |
---------------------------------------------------------
| 1 | aaa | 10 | 10 |
| 2 | bbb | 5 | 15 |
| 3 | ccc | 15 | 30 |
| 4 | ddd | 20 | 50 |
| 5 | eee | 30 | 80 |
or do you have a row with the total?
| ID | TEXT | Number of people |
----------------------------------------------
| 1 | aaa | 10 |
| 2 | bbb | 5 |
| 3 | ccc | 15 |
| 4 | ddd | 20 |
| 5 | eee | 30 |
| 6 | total | 80 |
Re: Calculated fields
Posted: 2018-06-05 06:52
by pasbonte
Hello
I want to "just" the total of a column.
| 1 | aaa | 10 |
| 2 | bbb | 5 |
| 3 | ccc | 15 |
| 4 | ddd | 20 |
| 5 | eee | 30 |
| 6 | total | 80 |
|TOTAL: | 160 |
Re: Calculated fields
Posted: 2018-06-05 07:16
by pasbonte

- 0506.PNG (38.92 KiB) Viewed 4805 times
Under the column Number of students
Re: Calculated fields
Posted: 2018-06-05 07:31
by pbottcher
Hi,
this can be set in the field definition.

- sum.JPG (36.93 KiB) Viewed 4802 times
Re: Calculated fields
Posted: 2018-06-05 08:15
by pasbonte
I am really a head in the air ..
Thank you