I'm trying to use a sum expression in Report Builder to sum all the quantities in each line of the sales shipment, but I'm going crazy. I have two lines, with 3 and 6 units each, so the total sum should be 9, but it shows 33. You can see some pics down below.
The issue you're experiencing with the sum expression in Report Builder could be due to a misconfiguration in the dataset or grouping in your report.
remove grouping and then check.
The best practice in Business Central for handling calculations like sums is to perform them in AL code and set the resulting values directly in the dataset for the report. This approach minimizes errors caused by dataset misconfiguration, grouping issues, or complex expressions in the report layout.
Was this reply helpful?YesNo
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.
175
Share
Report
All responses (
Answers (
