Use True (no quotes).
-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Wednesday, May 29, 2002 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] crystal calculation
Hey everyone!
I'm creating a calculation in Crystal. It keeps saying that a "Boolean is
required here". I'm not sure what to put in as a Boolean.
My calculation is basically: "If an invoice is open show me the sales minus
the invoice amount, otherwise show me just the sales"
This is the calculation: IIF ({InvcHead.OpenInvoice} =
'y',(({OrderDtl.OrderQty} * {OrderDtl.UnitPrice}) - {InvcDtl.ExtPrice}),
({OrderDtl.OrderQty} * {OrderDtl.UnitPrice}))
I believe that it needs to be where I have my little 'y' letter. But, I'm
not sure what a Boolean is and why I need it.
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
-----Original Message-----
From: Wendy Bowen (Pursche) [mailto:wpursche@...]
Sent: Wednesday, May 29, 2002 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] crystal calculation
Hey everyone!
I'm creating a calculation in Crystal. It keeps saying that a "Boolean is
required here". I'm not sure what to put in as a Boolean.
My calculation is basically: "If an invoice is open show me the sales minus
the invoice amount, otherwise show me just the sales"
This is the calculation: IIF ({InvcHead.OpenInvoice} =
'y',(({OrderDtl.OrderQty} * {OrderDtl.UnitPrice}) - {InvcDtl.ExtPrice}),
({OrderDtl.OrderQty} * {OrderDtl.UnitPrice}))
I believe that it needs to be where I have my little 'y' letter. But, I'm
not sure what a Boolean is and why I need it.
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]