1,085
Hi,
i'm doing a simple form with a query as datasource.
The query joins SalesTable with CustInvoiceJour and CustInvoiceTrans. I'm trying to group by a custom field on custTable and then retrieve the sum of LineAmount of invoices trans.
This works like a charm when i use this query in a view. But when I put it as datasource on a form all the amounts are zero. Is there a specific method to calculate aggregate fields as Sums?
Thank you in advance
*This post is locked for comments
Aha, OK.
I'm not aware of any such problem. Are you able to reproduce it in a minimized scenario (query with two fields, a form without anything else)? If so, can you share it?
Sorry guys, found it.
For your information:
you have to set the Fields node's "Dynamic" property to "No" and then add a new Sum field.
Then you are able to add this Sum field in your Form's grid as if it was an actual field of your datasource.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
