Topic: calculated field in the database

how do I in a field calculated within the database, to have the sum of a quantity of a product in a single product id

Domebil

Re: calculated field in the database

example: in an invoice I have a product 100 pieces I make 2 discharges of 50 pieces, how can I sum 50 + 50 = 100 in a single product ID inside a calculated field?

Domebil

3 (edited by sibprogsistem 2019-09-20 15:38:54)

Re: calculated field in the database

domebil wrote:

example: in an invoice I have a product 100 pieces I make 2 discharges of 50 pieces, how can I sum 50 + 50 = 100 in a single product ID inside a calculated field?

Table.product1+Table.product2

4 (edited by domebil 2019-09-20 15:50:28)

Re: calculated field in the database

does not work

Post's attachments

Attachment icon calcolare.jpg 24.28 kb, 139 downloads since 2019-09-20 

Domebil

5 (edited by domebil 2019-09-20 15:58:58)

Re: calculated field in the database

I make 2 invoices of 50 apples per total invoice I have 100 apples, now how can I show the total of the 2 invoices in a TableGrid without showing me the same product twice, since it is the same ID?

Domebil

Re: calculated field in the database

Hi Domebil,
Does doing it like this help you?  (see attached).
Derek.

Post's attachments

Attachment icon invoices.zip 336.81 kb, 542 downloads since 2019-09-20 

Re: calculated field in the database

Thanks a lot! it works great
Derek

Domebil