Thanks for clearing that up, Jim. I did have the true and false statements
in the wrong order.
Ted Kitch
-----Original Message-----
From: Jim Stetter [mailto:jimstetter@...]
Sent: Thursday, August 10, 2000 12:38 PM
To: vantage@egroups.com
Subject: RE: [Vantage] RB IF statement
I hate to nitpick, but the correct formula would be:
IIF (TotlMiscChrg <= 20, 0, TotalMiscChrg) notice the less than or equal
sign instead of greater than
or
IIF (TotlMiscChrg > 20, TotalMiscChrg,0) notice the "true" condition
yields the actual charge
The statements as originally supplied would result in just the opposite of
that intended!
Regards
Jim Stetter
-----Original Message-----
From: Ted Kitch [mailto:ted.kitch@...]
Sent: Thursday, August 10, 2000 1:10 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] RB IF statement
It is only displaying 0's and 1's, because that is what your formula is
telling it to do. If you only want to show the field TotlMiscChrg that is
over $20 then change your formula to the following:
IIF (TotlMiscChrg > 20, 0, TotalMiscChrg)
That should take care of the problem.
Hope this helps.
Ted Kitch
-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Thursday, August 10, 2000 12:06 PM
To: Vantage egroups list
Subject: [Vantage] RB IF statement
Okay all of you RB gurus; I have another statement question. I want to
display my Freight cost only if it is greater than $20. It seems to only be
displaying 0's and 1's. I would like it to display the cost ONLY IF it is
greater than $20.
IF(TotlMiscChrg > 20, 0,1)
Thanks Again!
Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
_____
<http://click.egroups.com/1/8117/13/_/411782/_/965928372/>
<http://click.egroups.com/1/8117/13/_/411782/_/965928372/>
_____
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
[Non-text portions of this message have been removed]
in the wrong order.
Ted Kitch
-----Original Message-----
From: Jim Stetter [mailto:jimstetter@...]
Sent: Thursday, August 10, 2000 12:38 PM
To: vantage@egroups.com
Subject: RE: [Vantage] RB IF statement
I hate to nitpick, but the correct formula would be:
IIF (TotlMiscChrg <= 20, 0, TotalMiscChrg) notice the less than or equal
sign instead of greater than
or
IIF (TotlMiscChrg > 20, TotalMiscChrg,0) notice the "true" condition
yields the actual charge
The statements as originally supplied would result in just the opposite of
that intended!
Regards
Jim Stetter
-----Original Message-----
From: Ted Kitch [mailto:ted.kitch@...]
Sent: Thursday, August 10, 2000 1:10 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] RB IF statement
It is only displaying 0's and 1's, because that is what your formula is
telling it to do. If you only want to show the field TotlMiscChrg that is
over $20 then change your formula to the following:
IIF (TotlMiscChrg > 20, 0, TotalMiscChrg)
That should take care of the problem.
Hope this helps.
Ted Kitch
-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Thursday, August 10, 2000 12:06 PM
To: Vantage egroups list
Subject: [Vantage] RB IF statement
Okay all of you RB gurus; I have another statement question. I want to
display my Freight cost only if it is greater than $20. It seems to only be
displaying 0's and 1's. I would like it to display the cost ONLY IF it is
greater than $20.
IF(TotlMiscChrg > 20, 0,1)
Thanks Again!
Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
_____
<http://click.egroups.com/1/8117/13/_/411782/_/965928372/>
<http://click.egroups.com/1/8117/13/_/411782/_/965928372/>
_____
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
[Non-text portions of this message have been removed]