Announcements
I want to display the total amount of all the line in the grid at bottom.
how to add the control in the design to achieve this
You create a display method on your datasource or table that sums all of the values. Then you can drag that display method onto your form design, but it cannot be within the grid. See form CustTrans as an example with total controls below the grid.
You can use the technique that I documented in the following blog post: Summarized values in AX form.
Thanks Martin for the logic, but in design how to display that sum where i need to add in the grid??
You create an unbound control and place it wherever you like (such as right bellow the grid). In my blog post, it's called Total. It's updated by the last statement of updateTotal() method: Total.realValue(...).
I was really new to this design part.
Sorry if was asking silly questions.
I have tried to add control in the grid, but it was coming as new column in the grid,
how to add the control exactly to display below the grid.
I am using detail transaction pattern, its not allowing me to add anywhere under the grid.
Am i doing wrong?
Could you brief me more.
I am not seeing any totals field in the custtrans form
Putting the control to the grid is indeed wrong - there you have your lines and the total is clearly not a property of individual lines.
I can't tell you which form pattern you should use because I don't know the purpose of your form. But you can ignore patterns for a moment, test the calculation of totals and deal with patterns after that.
By the way, which version of AX are you using?
I am using D365.
I am able to calculate the totals of all the lines, Now I was blocked to display that below the grid.
Can this be achievable? How?
Can you explain your current problem, please? How are you blocked? What did you do and what problem did encounter?
By the way, I'll move this thread to a D365 forum.
Martin,
I was trying to display some transaction lines in the grid and i want to display the total amount of all lines below the Grid.
I was able to calculate total amount but i am not getting where i need to add control in designer part to display the total amount.
when i try to add any control like group or real it was adding as column in the Grid, but i need it just below the Grid
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 658 Super User 2026 Season 1
André Arnaud de Cal... 632 Super User 2026 Season 1
Giorgio Bonacorsi 570
