try this
While SELECT SalesId FROM SalesLine GROUP BY salesID Sum(RemainSalesPhysical),sum(SalesPrice) ;
{
X= salesLine.remainsalesPhysical * SalesLine.salesPrice;
}
rzillmer <[EMAIL PROTECTED]> wrote:
Hello, I am new to Axapta so please forgive me if this is an easy
question.
I am trying to make a calculated field and a group by in the same
query. This is the query I'm trying to reproduce in Axapta:
SELECT Sum(SalesLine.RemainSalesPhysical*SalesLine.SalesPrice),
SalesLine.salesID FROM SalesLine GROUP BY SalesLine.salesID;
If you don't understand that, I'm trying to retrieve the total
amount for all the physical remaining on each sales order. I am
open to an easier way to do this if anyone knows of one.
I am trying to use as little code as possible in my reports but am
willing to use code if that is the only way to accomplish this.
Thanks in advance for any help!
Ryan
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
