Link to home
Start Free TrialLog in
Avatar of pradeepdevineni
pradeepdevineni

asked on

Calculating member query in Crystal Report crosstab

Hi
I have a crosstab in crystal reports 2008 in which there are two columns- Hours and Cost. Now i want to insert a new column- Rate( which is Cost divided by Hours). I am trying to write a query in the calculated member. Can anyone tell me how to write a division formula for this in calculated member.

Thank you.
Avatar of Mike McCracken
Mike McCracken

I assume th eissue isbecause of summing in the cross tab

Try

Sum({CostField}) / Sum({HoursField})

You may have to set the grouping
Sum({CostField},{RowField}) / Sum(HoursField},{RowField})

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of pradeepdevineni
pradeepdevineni

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial