web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Display Method to retu...

Microsoft Dynamics AX (Archived)

Display Method to return the SUM Value from Table Field

(0) Share

Report

Report

Posted on by Mohammed Altaf

435

Hi there,

I need to get the SUM of QTY Filed from CUSTINVOICETRANS Table, i wrote the display method i.e.

public display Qty QtySoldToDate()
{
CustInvoiceTrans custInvoiceTrans;
;

select sum(Qty) from custInvoiceTrans
where custInvoiceTrans.ItemId == this.ItemId;

return custInvoiceTrans.Qty;
}

but the problem here is QTY field is having both positive and negative values, but i need to get only the SUM of Positive values.

Can you please guide me to modify my above method, so that it returns only the SUM of positive values.

Thanks.

Regards

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Martin Dráb 239,208 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It's trivial - simply add && custInvoiceTrans.Qty > 0 to your where condition.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 16

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans