Announcements
No record found.
Hi Friends ,
Any one can tell me How to use Count ,Avg,sum,Max,Min field in AOT query.
*This post is locked for comments
What's the problem? Your picture already shows how to create such fields, so you must mean something else, but I don't know what it is.
Hi Martin,
After add count filed in query where i can use that is my question .
You'll access it in exactly the same way as if it was a normal field without any aggregation function applied. You can show it in a report, read it in X++ code and so on.
Thanks Martin
How do I refer to the sum or count fields in a report. I tried adding it to the Design and getting errors.
Ann2015, if you problem is related to this thread, i.e. it's about an AOT query, test whether your query works before trying to use in the report.
If your question isn't about AOT queries, please create a new thread and explain your problem in detail there. You'll surely agree with me that we can't know what errors you're getting unless you tell us about them.
Hi,
daxgeek.blogspot.com/.../select-count-sumfield-from-mytable.html
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
