How do you write BAQ Calculated field to show only some of the M

Put a criteria on the ordmisc table that that either equals specific misc charge codes (i.e. misccode = frgt) or,the misc charge amount > 0



________________________________
From: redrhyno13 <cwineinger@...>
To: vantage@yahoogroups.com
Sent: Wednesday, November 21, 2012 12:06 PM
Subject: [Vantage] How do you write BAQ Calculated field to show only some of the Misc charges

Â
We are running 905.700b2 in SQL.
The Controller wants a field on a BAQ that shows all of the Misc charges of an order except for two discount lines that show negative amounts. DSC and DSCN are the two codes.
I'm struggling with a code that either gives me a calculated field showing just the discount Misc charges or a field showing all Misc charges for the order minus the discounts.
Any help with this would be appreciated.

Thanks,

Chris Wineinger
ERP Specialist
Interior Systems, Inc.

Go Turkey!!!




[Non-text portions of this message have been removed]
We are running 905.700b2 in SQL.
The Controller wants a field on a BAQ that shows all of the Misc charges of an order except for two discount lines that show negative amounts. DSC and DSCN are the two codes.
I'm struggling with a code that either gives me a calculated field showing just the discount Misc charges or a field showing all Misc charges for the order minus the discounts.
Any help with this would be appreciated.

Thanks,

Chris Wineinger
ERP Specialist
Interior Systems, Inc.

Go Turkey!!!
Could you filter your query to not include those lines at all?

Austin Skrepak
Data Specialist / Developer
[EMAIL] askrepak@...<mailto:askrepak@...>

"Without ambition one starts nothing. Without work one finishes nothing. The prize will not be sent to you. You have to win it."
Ralph Waldo Emerson

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of redrhyno13
Sent: Wednesday, November 21, 2012 11:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How do you write BAQ Calculated field to show only some of the Misc charges



We are running 905.700b2 in SQL.
The Controller wants a field on a BAQ that shows all of the Misc charges of an order except for two discount lines that show negative amounts. DSC and DSCN are the two codes.
I'm struggling with a code that either gives me a calculated field showing just the discount Misc charges or a field showing all Misc charges for the order minus the discounts.
Any help with this would be appreciated.

Thanks,

Chris Wineinger
ERP Specialist
Interior Systems, Inc.

Go Turkey!!!



[Non-text portions of this message have been removed]