Thanks Shirley!!
----- Original Message -----
From: Shirley Graver
To: vantage@yahoogroups.com
Sent: Monday, June 10, 2002 1:55 PM
Subject: RE: [Vantage] RB Calc
Wendy,
Report builder doesn't like "OR" in that position of the formula. You
should probably write it something like this.
IIF(Invcdtl.invoicenum >0, (Sales - ExtPrice), IIF(ExtPrice = Sales,
Extprice,0))
Shirley
-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Monday, June 10, 2002 1:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB Calc
Hey everyone!
Another calculation problem for everyone! I'm trying to get this
calculation to work but it keeps giving me the infamous "invalid operation"
error. Anyone know how to correct my error?
IIF(InvcDtl.InvoiceNum > 0,(Sales - ExtPrice),0)
Or IIF(ExtPrice = Sales,ExtPrice,0)
Thanks!
Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan
[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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]