News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... sum of a report layout...

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

Unanswered

sum of a report layout field

(1) Share

Report

Report

Posted on by otmanel

39

hello , anyone can guide me how to do the sum of this field ; the total of (total amount) i tried =Sum(IIF(Fields!Qty~to_Invoice.Value > 0,Fields!Qty~to_Invoice.Value * Fields!Unit_Price100.Value, 0)) and =Sum(Fields!Qty__to_Invoice.Value * Fields!Unit_Price100.Value)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Khushbu Rajvi. 7,007 Moderator on at

Like (2)

Report

sum of a report layout field

Yes, I agree with ZHU. Calculating in the Report Object and passing the result to the layout is simpler than performing the calculation directly in the layout file.
Suggested answer

YUN ZHU 76,221 Super User 2024 Season 2 on at

Like (1)

Report

sum of a report layout field

Hi, Any error messages? Hopefully the information below can give you some hints.

https://www.youtube.com/watch?v=cb3_TQqaN8w

https://topic.alibabacloud.com/a/rdlc-report-functions_8_8_31488740.html

In addition, I personally recommend calculating in the Report Object and passing the result to the layout, rather than calculating on the layout file, which will be simpler.

Hope this helps.

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,605 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans