web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) AX development / Custo...

Microsoft Dynamics AX (Archived)

AX development / Customization

(0) Share

Report

Report

Posted on by Community Member

I did work on .net but new to AX, I want to make a view for Shop wise daily sales columns are:

Shop ID => Parameter Field

Date (column 1) || Gross Amount (Column 2) || Discount (Column 3) || Net Amount (Column 4)

The problem is, I cannot get sum function direct with view (in ax), so I created a query but when I use this query with my view it is not providing me fields which are sum fields.

Anybody have an idea how to do that?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

have a look at msdn.microsoft.com/.../bb314551.aspx and search for 'aggregate', it should give you an idea on how to add (for example) a sum to a view

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 24

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans