BAQ - Calculated Field

I think I had some weird bug going on. I reduced the calculated field
back to a single table and was still getting syntax errors. I then
removed it and put it back in and everything worked fine (though I did
include your space, thanks).

Ken


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stephen Edginton
Sent: Monday, January 21, 2008 8:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ - Calculated Field



Add a space, so /100 is / 100

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ken Williams
Sent: Monday, January 21, 2008 4:01 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ - Calculated Field

I'm trying to do an if/then/else on a calculated field but apparently
have syntax problems.

(if PODetail.PUM = "C" then (PODetail.UnitCost * PODetail.OrderQty /100)
else (PODetail.UnitCost * PODetail.OrderQty))

Appreciate any help.
Ken

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

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






[Non-text portions of this message have been removed]
I'm trying to do an if/then/else on a calculated field but apparently
have syntax problems.

(if PODetail.PUM = "C" then (PODetail.UnitCost * PODetail.OrderQty /100)
else (PODetail.UnitCost * PODetail.OrderQty))

Appreciate any help.
Ken


[Non-text portions of this message have been removed]
Add a space, so /100 is / 100





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Williams
Sent: Monday, January 21, 2008 4:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ - Calculated Field



I'm trying to do an if/then/else on a calculated field but apparently
have syntax problems.

(if PODetail.PUM = "C" then (PODetail.UnitCost * PODetail.OrderQty /100)
else (PODetail.UnitCost * PODetail.OrderQty))

Appreciate any help.
Ken

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





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