Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summarize groups "If Then Statements" 1

Status
Not open for further replies.

Dednutts

Technical User
May 31, 2007
6
CA
Hi there,
I have a BO report that groups total hours for 3 people. Each person has a different $ value. I need to multiply the hours * $

if ({person.lastname})="person1" then Sum ({@time}, {Person.LastName})*(12.50)
or if ({person.lastname})="person2" then Sum ({@time}, {Person.LastName})*(18.20)
else if ({person.lastname})="person3" then Sum ({@time}, {Person.LastName})*(21.25)
Thanks
 
You're mixing OR with ELSE which is not quite okay in any case. What is the version you're working with?

Ties Blom

 
You're better off to post this in a Crystal forum. This one really deals with the classic BO products.

Steve Krandel
Intuit
 
Thanks, I'm a newbie, I'll I thought Business Objects and Crystal were the same. I'll look & post in crystal forum.

Cheers
 
BO does own Crystal. But, if you have specific "how-to" questions, the Crystal forums will get you a better response.

Steve Krandel
Intuit
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top