How to use Count ,Avg,sum,Max,Min field in AOT query.

(0) Share

Report

Posted on by Vikas_AX_Blogs

875

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

I have the same question (0)

All responses (7)

Answers (1)

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Vikas_AX_Blogs 875 on at

Like (0)

Report

Hi Martin,

After add count filed in query where i can use that is my question .

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Vikas_AX_Blogs 875 on at

Like (0)

Report

Thanks Martin

Was this reply helpful? Yes No
Ann2015 1,128 on at

Like (0)

Report

How do I refer to the sum or count fields in a report. I tried adding it to the Design and getting errors.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,648 on at

Like (0)

Report

Hi,

daxgeek.blogspot.com/.../select-count-sumfield-from-mytable.html

Was this reply helpful? Yes No