Calculation in BAQ and if statements

Yahoo Archive
1
Larry,

Here is an example that I use for calculating. Maybe I can lead by example?
Let me know if you need more info.

IF (JobMtl.SalvageQtyPer = 0) THEN (LaborDtl.LaborQty * JobMtl.QtyPer *
Part.PurchasingFactor * .275) ELSE (LaborDtl.LaborQty * JobMtl.QtyPer *
JobMtl.SalvageQtyPer) COLUMN-LABEL "Off-Fall lbs."

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Larry Barriere
Sent: Tuesday, December 27, 2005 11:25 AM
To: Vantage Group
Subject: [Vantage] Calculation in BAQ and if statements


I'm trying to create a BAQ using OrdDtl and OrdMisc. What I would like to do
is a calculation using this :
(OrderDtl.OrderQty * OrderDtl.UnitPrice) + OrderMsc.MiscAmt.
The result are ? mark if some of the orders do not have any MiscAmt. If I
have a MiscAmt it does add it up properly.
I tried to create an "if" statement but if haven't been able to do it in
the Calculated field.
Has anyone been able to do an if statement and if so could I see an
example.
Thank you
Larry Barriere
barriere@...


---------------------------------
Yahoo! for Good - Make a difference this year.

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




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
I'm trying to create a BAQ using OrdDtl and OrdMisc. What I would like to do is a calculation using this :
(OrderDtl.OrderQty * OrderDtl.UnitPrice) + OrderMsc.MiscAmt.
The result are ? mark if some of the orders do not have any MiscAmt. If I have a MiscAmt it does add it up properly.
I tried to create an "if" statement but if haven't been able to do it in the Calculated field.
Has anyone been able to do an if statement and if so could I see an example.
Thank you
Larry Barriere
barriere@...


---------------------------------
Yahoo! for Good - Make a difference this year.

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