RB IF statement


(system) #1
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]

(system) #2
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@...



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



_____

<http://click.egroups.com/1/7851/13/_/411782/_/965927243/>
<http://click.egroups.com/1/7851/13/_/411782/_/965927243/>

_____

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]

(system) #3
IIF(TotlMiscChrg>20, TotlMiscChrg,0)

The Statement is IIF(condition,then,else)

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565

> -----Original Message-----
> From: Wendy Pursche [SMTP:wpursche@...]
> Sent: Thursday, August 10, 2000 1: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@...
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: 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.)

(system) #4
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@...

(system) #5
Hi Wendy,

iif(TotlMiscChrg >20, TotlMiscCharge,0) You'll need to rename this
calculation something other than TotlMiscCharge and then insert it where you
want the freight cost to appear.

HTH

Chris

-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Thursday, August 10, 2000 1: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@...



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




We no longer allow attachments to files. To access/share Report Files,
please go to the following link: 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.)