1. Re: Export Utility Calculated Fields
From: "Troy Funte" <tfunte@...>
Message: 1
Date: Mon, 1 Oct 2001 01:32:01 -0400
From: "Troy Funte" <tfunte@...>
Subject: Re: Export Utility Calculated Fields
Wayne,
Thanks. I was able to add a field label to a calculation as you
mentioned. Two notes about it:
1. I had to enter the field label statement AFTER the "Field Name" in the
calculation, otherwise it stuck the label on the PREVIOUS field's heading in
Excel. So an acceptable statement would be:
OrderRel.OurReqQty column-label "Required Qty"
2. You can do simple sum calculations such as:
OrderRel.OurJobShippedQty + OrderRel.OurStockShippedQty column-label
"Shipped Qty"
but I don't know about "aggregate" calculations. It sure would be nice to be
able to aggregate -- as in combining multiple bin locations in the
PartBin.OnHandQty for instance. Anyone know how to do this in a Vantage
Export?
Troy
From: "Troy Funte" <tfunte@...>
Message: 1
Date: Mon, 1 Oct 2001 01:32:01 -0400
From: "Troy Funte" <tfunte@...>
Subject: Re: Export Utility Calculated Fields
Wayne,
Thanks. I was able to add a field label to a calculation as you
mentioned. Two notes about it:
1. I had to enter the field label statement AFTER the "Field Name" in the
calculation, otherwise it stuck the label on the PREVIOUS field's heading in
Excel. So an acceptable statement would be:
OrderRel.OurReqQty column-label "Required Qty"
2. You can do simple sum calculations such as:
OrderRel.OurJobShippedQty + OrderRel.OurStockShippedQty column-label
"Shipped Qty"
but I don't know about "aggregate" calculations. It sure would be nice to be
able to aggregate -- as in combining multiple bin locations in the
PartBin.OnHandQty for instance. Anyone know how to do this in a Vantage
Export?
Troy
----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Sent: Friday, September 28, 2001 12:45 PM
Subject: Re: [Vantage] Export Utility Calculated Fields
At 12:32 PM 9/28/2001 , you wrote:
>Now wait a second, Wayne. Where in the world do you put that line? IN
the
>Query statement somewhere?
Oops... sorry. Vantage 4 added calculated fields in the export
utility. Under the fields tab, there is Add and Edit Calculation. That
whole line I posted was copied from the Edit Calculation box.
Anyone (Lonnie?) know if you can write queries to export only subtotals,
like an aggregate field in RB?
-Wayne