News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Add calculated query f...

Microsoft Dynamics AX (Archived)

Add calculated query field to a Userform

(0) Share

Report

Report

Posted on by Community Member

Hi,

Is it possible to, after creating a custom query that has a calculated field (i.e. the sum of the QtyOrdered on the SalesLine table), add that field into a grid of a new userform?

I have tried that, but only when I drag a field from the existing field list of SalesLine table the field adding works... when I try to drag that specific calculated field onto the userform Grid, it doesn't let me add it...

Is what I am trying to do not possible? And if so, If I am trying to get a sum of something, how can I show it on a userform?

Thanks in advance.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Sohaib Cheema 46,614 User Group Leader on at

Like (0)

Report

RE: Add calculated query field to a Userform

that is absolutely possible. but your sum must be based on any Group(ing)

you can create query as specified in this thread.

then after creating query you have two options

1) drag that query directly to any form and use it

or

create a view based on your query and use it that view as DS of form

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics AX (Archived)

#1

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2

Community Member 48

#3

shanawaz davood basha 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans