web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Page with repeater - h...
Microsoft Dynamics NAV (Archived)

Page with repeater - how to show sum of weight which comes from a different page/table

(0) ShareShare
ReportReport
Posted on by mbr 5,136

I have a Main Page with repeater container which acts like a grid.  I want to show total weight of each record.  The weight can be retrieved by drilling down through 2 pages given the record selected from the Main Page.  I.e., Main page is A.  When you dbl click onto the row in Page A, you are routed into Page B to show children of the record from Page A.  Then to get the weight, you would have to go to Actions and push a button that goes to Page C which is a child page of Page B.  There in Page C, you would see the weight for all children of Page B.  I want to calculate the sum of all the weights in Page C and show that in Page A.  Any suggestions?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    Hi mbr,

    that's a typical use case for a flowfield. But we need to think tables here... I assume the three pages have three separate (but related) tables? As long as you have the desired primary key of table A also in table C, you can calculate a total of a value in C for A. This is also used in NAV standard for all places where detailed ledger entries are used. An example would be T18 (customer), T21 (customer ledger entry), T379 (detailed customer ledger entry). In T18 the field "Balance (LCY)" is directly calculated with the detailed ledger entries:

    Sum("Detailed Cust. Ledg. Entry"."Amount (LCY)" WHERE (Customer No.=FIELD(No.),Initial Entry Global Dim. 1=FIELD(Global Dimension 1 Filter),Initial Entry Global Dim. 2=FIELD(Global Dimension 2 Filter),Currency Code=FIELD(Currency Filter)))

    The detailed ledger entries also represent the amounts calculated in the customer ledger entries for amount, remaining amount and so on. The binding field is in this case "No." (T18, primary key) which becomes "Customer No." in T21 and T379.

    So, the way to go in your example would be to create a flowfield in table A that uses table C as calcformula. This works as long as the primary key fields of table a are available for filtering in table C.

    with best regards


    Jens

  • mbr Profile Picture
    mbr 5,136 on at

    It worked! Thanks jens!

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans