Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Unanswered

sum of a report layout field

Posted on by 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)
Categories:
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 1,487 on at
    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 Profile Picture
    YUN ZHU 68,480 Super User 2024 Season 2 on at
    sum of a report layout field
    Hi, Any error messages? Hopefully the information below can give you some hints.
     
    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

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans