Report Builder BC - Sum Expression

(1) Share

Report

Posted on by LM-26090852-0

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:

Business Central

All responses (1)

Answers (1)

Verified answer

Khushbu Rajvi. 4,553 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.