I have 2 tables in my form and 2 tables have a relation with header and line.
In my form (Header) I would like to show sum(Amount) for all data in line.
How should i do? please advise.
Please mark answer/s verified so it can help someone in future.
Thank you both now I create method and this issue are solved.
Thank you very much.
As Girish mentioned, best to create a display method. Add the display method at header level which will calculate total of all related sales order lines and export it to excel.
I would suggest you add a display method to show the total line amount against that header. During excel export from the form you can be able to see that display method in the excel also.
Thanks,
Girish S.
Thank for both but My users want output that header need to have summary because at the end they need to export to be an excel to their boss.
Do you have any sugguestion?
Hi,
You can right click that column and click on "Total this column" - This is a inbuilt feature available in d365.
Thanks,
Girish S.
Hi, You can do it with 'New Grid Control' feature without customization. Check this article
www.linkedin.com/.../calculate-fields-totals-d365fo-hylke-britstra
If you want to do via code and don't want to manage personalization's for users, then check this article
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156