Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,785
Jainam M. Kothari 1,007 Super User 2025 Season 2
YUN ZHU 948 Super User 2025 Season 2
