web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Select sum count

Microsoft Dynamics AX (Archived)

Select sum count

(0) Share

Report

Report

Posted on by Community Member

Hello everyone!

I need to do smt like that...

Select count(RecID) sum(Field) from MyTable

I have to do this in one select but i dont know how. Any ideas?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

Hi Juras,

I think you need to make count and sum in the same select query .

The below select query will give the both the Sales Line record count and the sum of sales quantity.

Code :

static void Test_Data(Args _args)

{

SalesLine salesLine;

select count(RecId),sum(SalesQty) from salesLine;

info(strFmt("Number of Records : %1 Total Quantity : %2",SalesLine.RecId,SalesLine.SalesQty));

}

Output :

If the above thing is not suit for you means please explain how exactly you want or if you satisfied with this answer please verify it.

Thanks,

Malleswaran

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your answer. I was trying everything, but i forget about comma sign! Thanks a lot ;)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Juras,

Could you please make my answer as verified answer(verify my answer ).

Thanks in Advance,

Malleswaran

Was this reply helpful? Yes No
karthickarden 135 on at

Like (0)

Report

Hello Malleswaran,

Could you help to find out the list of custom tables and System tables in the AOT.

Is there any query available to find out the list?

Thanks,

Karthick.M

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans