Formula help calculating percentages

[msuit]

Hi all,

I am having a problem calculating a percentage of work orders for a specific group. They report needs to show the total number of work orders between a certain date range. This is working fine.
The problem is that when I break the number into groups (departments) I can get the number of work orders and percentage for each department. I just want to veiw on group (department) with that percentage of the total amount of work orders. If I list just the group that I want the percentage is 100%. Because it is only counting that groups work orders and not considering those of the other groups.
Can any one help me with this. I am still new to the formulas in CR11 and have no idea where to begin.

thanks

 

[synapsevampire]

What does break the number into groups mean?

You might create a formula such as:

left({table.workorder},4)

to create a department field to group on.

Then you can create precentages based on this.

Otherwise, try posting technical information isstead:

Database/connectivity used
Example data
Expected output

-k

 

[lbass]

There are a number of ways to do this. A simple way would be to remove any reference to the departments in the record selection formula, and allow all department data to be returned. Insert a group on department, and insert the summary you would like, and the percentage formula. Then you could create a parameter {?dept} and go to report->selection formula->GROUP and enter:

{table.department} = {?dept}

This will display only the one department, but the underlying data will still be available for the percentage calculation.

Another approach would be to add a command that returns the sum of all work orders that fall within the date range. Then you would link the command to the main report on the date range parameter. You could then use the sum in your calculation.

-LB