Get the count of rows and sum per month

(1) Share

Report

Posted on by atzdgreat

Objective: Get the count of rows and Sum of Net Payables per month.

Sample Data:

Net Payables	Date Created
14,523.00	1-Dec-24
34,253.00	2-Dec-24
23,562.00	1-Jan-25
135,664.00	3-Jan-25
1,234,566.00	5-Jan-25

Code so far:

ClearCollect(TempTransCol,'Temp Transaction'); 
ClearCollect(
    ColGroupedData,
    AddColumns(
        GroupBy(
            TempTransCol,
            Text('Date Created', "mm-yyyy"),
            GroupItem
        ),
        TotalCount,
        CountRows(GroupItem),
        SumNet,
        Sum(GroupItems,'Net Payable')
    )
);
 
Error Received: Name isn't valid. 'Date Created' isn't recognized.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Mitanshu 1,658 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Can you try the code below:

ClearCollect(TempTransCol, 'Temp Transaction'); ClearCollect( ColGroupedData, AddColumns( GroupBy( TempTransCol, Text('Date Created', "mm-yyyy"), "GroupItem" ), "TotalCount", CountRows(GroupItem), "SumNet", Sum(GroupItem, 'Net Payables') ) );

The group name inside GroupBy should be enclosed in quotes, as it's used as a field name in AddColumns.

Was this reply helpful? Yes No
WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @atzdgreat

What is your data source type and is 'Date Created' a field you added (if using SharePoint, the field name is Created )? Also what is the data type of this field ? Note you do not need quotes around the field names as per the other response.

Was this reply helpful? Yes No