If Then summary for groups Crystal 11

[Dednutts]

Hi there,
I have a Crystal 11 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

 

[dgillz]

So what have you tried, and what has failed? If you are getting an error message, post it

The formula you posted looks pretty good, just take out the or and fix your parens.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Dednutts]

Hi Dave

"A Boolean is required Here"
if ({person.lastname})="person1" then Sum ({@time}, {Person.LastName})*(12.50)

Steve

 

[dgillz]

Where are you going to create this formula? you should open the field explorer, right click on the word "formula" and select "new".

After you save your formula drag it onto the report canvas in the group footer section.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[lbass]

After creating the formula in the correct place, replace your "or" with "else".

-LB

 

[Dednutts]

Thanks everyone, I replaced "or" with "else" and it works fine.

Thanks again

Steve

 

[dgillz]

I suggested that in my first post

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry