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
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
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