# RB Question **Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9) **Created:** 2000-08-09 14:08 UTC **Views:** 422 **Replies:** 4 **URL:** https://www.epiusers.help/t/rb-question/725 --- ## Post #1 by @system
thank you all

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, August 09, 2000 10:07 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] RB Question


IIF(Value1 =0 and Value2 = 0,Whatever + 1," ")

Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 3.00.614, Progress 8.3A

-----Original Message-----
From: Trzaska, Mark [mailto:mtrzaska@...]
Sent: Wednesday, August 09, 2000 09:23 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] RB Question


It looks like i can use a case statement, but if i could im not sure how to
format. Basically i havbe to look at 5 fields if the value of all 5 are 0
then a variable is increased by 1



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.)
--- ## Post #2 by @system
It looks like i can use a case statement, but if i could im not sure how to
format. Basically i havbe to look at 5 fields if the value of all 5 are 0
then a variable is increased by 1

-----Original Message-----
From: Trzaska, Mark [mailto:mtrzaska@...]
Sent: Wednesday, August 09, 2000 9:17 AM
To: Vantage (E-mail)
Subject: [Vantage] RB Question


Hello,
Need some help. Can you put multiple if statements in a calculation in
report builder. Doing a report for 4.0 a quote report and almost done. Just
need this bit of info. If you can could you post an example of the format.

Thanx



[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.)
--- ## Post #3 by @system
Can you just add the fields together? and then just use
one iif statement
--> iif(f1+f2+f3+f4+f5=0, x+1, x)

Tim Care
Electro Chemical Finishing
----- Original Message -----
From: Trzaska, Mark <mtrzaska@...>
To: <vantage@egroups.com>
Sent: Wednesday, August 09, 2000 10:22 AM
Subject: RE: [Vantage] RB Question


> It looks like i can use a case statement, but if i could im not sure how
to
> format. Basically i havbe to look at 5 fields if the value of all 5 are 0
> then a variable is increased by 1
>
> -----Original Message-----
> From: Trzaska, Mark [mailto:mtrzaska@...]
> Sent: Wednesday, August 09, 2000 9:17 AM
> To: Vantage (E-mail)
> Subject: [Vantage] RB Question
>
>
> Hello,
> Need some help. Can you put multiple if statements in a calculation in
> report builder. Doing a report for 4.0 a quote report and almost done.
Just
> need this bit of info. If you can could you post an example of the format.
>
> Thanx
>
>
>
> [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.)
>
>
>
> 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.)
>
--- ## Post #4 by @system
ill try it

-----Original Message-----
From: Tim Care [mailto:ecfmis@...]
Sent: Wednesday, August 09, 2000 10:02 AM
To: vantage@egroups.com
Subject: Re: [Vantage] RB Question


Can you just add the fields together? and then just use
one iif statement
--> iif(f1+f2+f3+f4+f5=0, x+1, x)

Tim Care
Electro Chemical Finishing
----- Original Message -----
From: Trzaska, Mark <mtrzaska@...>
To: <vantage@egroups.com>
Sent: Wednesday, August 09, 2000 10:22 AM
Subject: RE: [Vantage] RB Question


> It looks like i can use a case statement, but if i could im not sure how
to
> format. Basically i havbe to look at 5 fields if the value of all 5 are 0
> then a variable is increased by 1
>
> -----Original Message-----
> From: Trzaska, Mark [mailto:mtrzaska@...]
> Sent: Wednesday, August 09, 2000 9:17 AM
> To: Vantage (E-mail)
> Subject: [Vantage] RB Question
>
>
> Hello,
> Need some help. Can you put multiple if statements in a calculation in
> report builder. Doing a report for 4.0 a quote report and almost done.
Just
> need this bit of info. If you can could you post an example of the format.
>
> Thanx
>
>
>
> [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.)
>
>
>
> 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.)
>




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.)
--- ## Post #5 by @system
IIF(Value1 =0 and Value2 = 0,Whatever + 1," ")

Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 3.00.614, Progress 8.3A

-----Original Message-----
From: Trzaska, Mark [mailto:mtrzaska@...]
Sent: Wednesday, August 09, 2000 09:23 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] RB Question


It looks like i can use a case statement, but if i could im not sure how to
format. Basically i havbe to look at 5 fields if the value of all 5 are 0
then a variable is increased by 1
--- **Canonical:** https://www.epiusers.help/t/rb-question/725 **Original content:** https://www.epiusers.help/t/rb-question/725