Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

How to make a child list of a parent list?

HI!!
I have the table rptCartera, independent for a report, that contains a virtual list column. This list returns only the loans that have a balance on the cut-off date. The primary key is the credit_ID.

List_Loans = Filter(Loans,AND([DisbursementDate]<=[_THISROW].[Cut-offDate],[Capital]>SUM(SELECT(Payments[Capital],AND([credit_ID]=[_THISROW-1].[credit_ID ],[Date]<=[_THISROW].[Cut-offDate])))))

Based on the List_Loans column, I need another column that returns the sum of the payments made for each loan that the List_Loans column returns.

So far I have been able to make a list of payments, but what I want is a list that shows the sum of each credit_ID in the List_loans column.
SELECT(Payments[Capital],AND(IN([Credit_ID],[_THISROW].[Loan_List]),([Date]<=[_THISROW].[Cutoff_Date]))) Thank

Thanks 

@MultiTech  @Koichi_Tsuji  @LeventK 

Captura de pantalla 2024-09-21 193225.png

0 2 157
2 REPLIES 2
Top Labels in this Space