Announcements
No record found.
Hi All,
In a report I have to display the Average row-wise.
Attached is the expected report layout.
I have to sum each value of the row and divide it by total no of customers on the report.
How can I achieve this ? Please suggest.
Write code to sum your values and add a column in your excel export or export a new column with a calculation.
You may want to look deeper into the code of your object to understand the Excel methods in NAV. Also have a look in other Excel export objects of Navision. They give a lot of hints.
I don't want to deal with Excel import or export.
It is just a layout.
I have to calculate the sum and average on RDLC only.
in your custom report add a new field "average" in the line dataitem, add a new variable average to the report vars.
in trigger OnAfterGetRecord add the code to calculate the average value.
in the layout add the new field.
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!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 1,965 Super User 2026 Season 1
YUN ZHU 1,125 Super User 2026 Season 1
Dhiren Nagar 961 Super User 2026 Season 1
