IFF Function

Yahoo Archive
1
You can't have the result be both a string expression ("") and a numeric
expression (OurInventoryShipQty). You will have to either convert the
number to a string (string()) or else return a ? or 0 instead of null.




[Non-text portions of this message have been removed]
2
I am trying to create this function. If the Shipdtl.invoiced=Yes the I want to print a blank. If it is False than I want to print the 'OurInventoryShipQty' value.

This is what I have but it doesn't work. What am I doing wrong?

IIF(Invoiced = YES, '' ,OurInventoryShipQty)

Thanks!
Jasper





[Non-text portions of this message have been removed]
3
IIF(Invoiced = YES, '' ,STRING(OurInventoryShipQty,'>>>,>>9.99')

Patrick Winter


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, May 09, 2003 9:05 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] IFF Function


I am trying to create this function. If the Shipdtl.invoiced=Yes the I want
to print a blank. If it is False than I want to print the
'OurInventoryShipQty' value.

This is what I have but it doesn't work. What am I doing wrong?

IIF(Invoiced = YES, '' ,OurInventoryShipQty)

Thanks!
Jasper





[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 http://docs.yahoo.com/info/terms/
4
Thanks once again Patrick. Works great!!

Jasper

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, May 09, 2003 10:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] IFF Function


IIF(Invoiced = YES, '' ,STRING(OurInventoryShipQty,'>>>,>>9.99')

Patrick Winter


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, May 09, 2003 9:05 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] IFF Function


I am trying to create this function. If the Shipdtl.invoiced=Yes the I want
to print a blank. If it is False than I want to print the
'OurInventoryShipQty' value.

This is what I have but it doesn't work. What am I doing wrong?

IIF(Invoiced = YES, '' ,OurInventoryShipQty)

Thanks!
Jasper





[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 http://docs.yahoo.com/info/terms/



Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1564416/R=0/*http://www.netflix.com/Default?mqso=60164797&partid=3170658>
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1564416/rand=683614358>

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 <http://docs.yahoo.com/info/terms/> .




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