Page 1 of 1
Sum of Auto-fill column AppGini 5.98
Posted: 2022-02-12 19:28
by Moh Youba
Hello
I am trying to get sum of Auto-fill column but do not work. Any help please.
Thank you
- Slide2.JPG (108.54 KiB) Viewed 1416 times
- Slide1.JPG (78.26 KiB) Viewed 1416 times
Re: Sum of Auto-fill column AppGini 5.98
Posted: 2022-02-13 10:28
by jsetzer
Autofill fields are just lookups: They store the foreign key of the master-record, not the chosen display value. They show the chosen display value in UI, only.
Check the table data of actes with your SQL-tool. You will see that patients.montant will hold the primary key of selected record of actes table, not the value of actes.tarif.
tarif is just the display formula for this autofill field. This is not a bug but by design.
If you need the (numeric) values of actes.tarif, you may consider adding a calculated field reading the tarif from the related master table. Then check [x] Sum for the new calculated field.
Re: Sum of Auto-fill column AppGini 5.98
Posted: 2022-02-13 10:37
by Moh Youba
thank you sir, I understand now.
Going to try.
Best regards,