IFF Function questions

Yahoo Archive
1
Try double quotes with nothing in-between. ""


Mark Dupuis


From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, August 11, 2003 11:38 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] IFF Function questions


I need to make a calculation that looks at a character class. If that value
is true then it would return a dollar value. If false, I just want it
blank. I am using the IFF function that looks like this:

IIF(Class = 'TOOL' ,totdeb, value)

The totdeb is a calculated field that returns the price of the tool. The
problem I'm having is that I can't figure out what I need to put in the
value to return a blank. I think it's asking for a numeric value because
the first condition is a numeric value. Any ideas?

Thanks,

Jasper




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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=17050071
83:HM/A=1693353/R=0/SIG=11t71ok4g/*http://www.netflix.com/Default?mqso=60178
294&partid=3170658> click here

<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmai
l/S=:HM/A=1693353/rand=993923898>

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]
2
I need to make a calculation that looks at a character class. If that value is true then it would return a dollar value. If false, I just want it blank. I am using the IFF function that looks like this:

IIF(Class = 'TOOL' ,totdeb, value)

The totdeb is a calculated field that returns the price of the tool. The problem I'm having is that I can't figure out what I need to put in the value to return a blank. I think it's asking for a numeric value because the first condition is a numeric value. Any ideas?

Thanks,

Jasper




[Non-text portions of this message have been removed]
3
Try ? (question mark). This would set the value as unknown if you don't want it to be zero. Then in case it is used in aggregates (like to find an average or total over a group) check mark "ignore unknowns".
-Todd C.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, August 11, 2003 10:38 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] IFF Function questions


I need to make a calculation that looks at a character class. If that value is true then it would return a dollar value. If false, I just want it blank. I am using the IFF function that looks like this:

IIF(Class = 'TOOL' ,totdeb, value)

The totdeb is a calculated field that returns the price of the tool. The problem I'm having is that I can't figure out what I need to put in the value to return a blank. I think it's asking for a numeric value because the first condition is a numeric value. Any ideas?

Thanks,

Jasper




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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1693353/R=0/SIG=11t71ok4g/*http://www.netflix.com/Default?mqso=60178294&partid=3170658> click here
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1693353/rand=993923898>

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]
4
Excellent!!

Thanks Todd!!

Jasper

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, August 11, 2003 11:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] IFF Function questions


Try ? (question mark). This would set the value as unknown if you don't want it to be zero. Then in case it is used in aggregates (like to find an average or total over a group) check mark "ignore unknowns".
-Todd C.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, August 11, 2003 10:38 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] IFF Function questions


I need to make a calculation that looks at a character class. If that value is true then it would return a dollar value. If false, I just want it blank. I am using the IFF function that looks like this:

IIF(Class = 'TOOL' ,totdeb, value)

The totdeb is a calculated field that returns the price of the tool. The problem I'm having is that I can't figure out what I need to put in the value to return a blank. I think it's asking for a numeric value because the first condition is a numeric value. Any ideas?

Thanks,

Jasper




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



Yahoo! Groups Sponsor

ADVERTISEMENT
< http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1693353/R=0/SIG=11t71ok4g/*http://www.netflix.com/Default?mqso=60178294 <http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1693353/R=0/SIG=11t71ok4g/*http://www.netflix.com/Default?mqso=60178294&partid=3170658> &partid=3170658> click here
< http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1693353/rand=993923898>

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]



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1693353/R=0/SIG=11t71ok4g/*http://www.netflix.com/Default?mqso=60178294&partid=3170658> click here
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1693353/rand=444172394>

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]