AX / D365FO – Group by and Aggregate functions on select statement

Thiis simple code shows how to do a Query using a select statement with GROUP BY clause and Aggregate functions like COUNT, SUM, AVG, etc..

CustTable custTable;
    while select count(RecId), CustGroup from custTable
        group by CustGroup
        order by custTable.RecId desc
        info(strFmt("%2 - %1", custTable.RecId, custTable.CustGroup));

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s