Grouping in linked entries

52 views
Skip to first unread message

Rakab Aman

unread,
Jun 2, 2021, 1:47:16 PM6/2/21
to mementodatabase
Hi, I have a finance library with all expenses of bank in which I have linked togather multiple entries (within the same library) for loan that has been given and collected. But I want to group them togather so that I can see all the linked entries grouped togather, so it can calculate aggregate value and can see whats balance.

Bill Crews

unread,
Jun 2, 2021, 2:37:05 PM6/2/21
to Rakab Aman, mementodatabase
Could you give a quick, ideally somewhat visual example? You're link from the library back into the same library? On all the link fields? When you say grouped, there is of course grouping in the entries list. It's pretty nice with subtotals & other sub-aggregations per group. Will that suit your needs? If so, open the right-side menu (if mobile), select grouping, identify the fields to group on.

On Wed, Jun 2, 2021 at 1:47 PM Rakab Aman <raka...@gmail.com> wrote:
Hi, I have a finance library with all expenses of bank in which I have linked togather multiple entries (within the same library) for loan that has been given and collected. But I want to group them togather so that I can see all the linked entries grouped togather, so it can calculate aggregate value and can see whats balance.

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/10abc232-cd03-43ac-b367-ae338ace3a8bn%40googlegroups.com.

Rakab Aman

unread,
Jun 3, 2021, 4:37:01 AM6/3/21
to mementodatabase

I'll Try to give example. I have uploaded my library template by name expense and saving.
E. G
There is an expense entry on account as loan given on some particular date. So the amount is recorded as debt. 

Now some other date that amount has been returend, so an entry is made for that date with loan as credit. Plus a link is made with the previous entry of debt. Upto here everything is fine

Now when i filter all expense so only loan entries are shown. And then group them with linked entries. But I don't know why but only one entry shows up properly with both debt and credit entries grouped togather. Rest they do not get grouped or show only that has one entry but in actual they have atleast two entry linked togather for one debt and one credit

Added pics below also
Screenshot_20210603_112643_edit_83922802564797.jpg
Screenshot_20210603_112706_edit_83621587634635.jpg

Rakab Aman

unread,
Jun 3, 2021, 4:40:43 AM6/3/21
to mementodatabase
My to get them show up as the pic two where all the linked entries gets grouped togather and the aggregate calculates the balance of the gorpes entries. 
Reply all
Reply to author
Forward
0 new messages