News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Report Builder BC - Su...

Small and medium business | Business Central, N...

Answered

Report Builder BC - Sum Expression

(1) Share

Report

Report

Posted on by LM-26090852-0

46

Good day,

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.

I dont know what else to do.

Categories:

Dynamics 365 Business Central

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Khushbu Rajvi. 5,856 Moderator on at

Like (2)

Report

Report Builder BC - Sum Expression

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2

Martin Dráb 230,371 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans