Sum of Auto-fill column AppGini 5.98

[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 1404 times

Slide1.JPG (78.26 KiB) Viewed 1404 times

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

[Moh Youba]

thank you sir, I understand now.
Going to try.

Best regards,