Adding fields 1

[ptrifile]

I have a field that lists Territories and then another that shows the "Territories" Service level and another that shows how many calls for each "Territory".

How would i be able to get a combined weighted service level by number of calls for only 2 of the "territories" not all that are displayed?

Thanks in advance

Paul

 

[lbass]

You could create an outer group using a formula like this:

if {table.territory} in ["A","B"] then "Combined A and B Territories" else
{table.territory}

Then you can insert summaries at the group level. Not sure what you mean by weighting.

-LB

 

[ptrifile]

Let me try explaining this a little more and please tell me if the forumla above should get me the desired results.

I have 2 segments of business that have 8 total territories each. These are all displayed on the report


Seg A Territory 1 80 <--Service Level
Seg A Territory 2 80 <--Service Level
Seg A Territory 3 80 <--Service Level
Seg A Territory 4 80 <--Service Level
Seg A Territory 5 80 <--Service Level
Seg A Territory 6 80 <--Service Level
Seg A Territory 7 80 <--Service Level
Seg A Territory 8 80 <--Service Level

Seg B Territory 1 40 <--Service Level
Seg B Territory 2 40 <--Service Level
Seg B Territory 3 40 <--Service Level
Seg B Territory 4 40 <--Service Level
Seg B Territory 5 40 <--Service Level
Seg B Territory 6 40 <--Service Level
Seg B Territory 7 40 <--Service Level
Seg B Territory 8 40 <--Service Level

What i would like to see is the average each territory combined is and just show the following on the report:

Combined Territory 1 60
Combined Territory 2 60
Combined Territory 3 60
Combined Territory 4 60
Combined Territory 5 60
Combined Territory 6 60
Combined Territory 7 60
Combined Territory 8 60


Sorry if i didn't explain this properly in my first message.

as always i really appreciate the help/

 

[lbass]

Instead of grouping on Segment, insert a group on Territory. Then you can insert an average on service level at the territory level.

-LB

 

[ptrifile]

I have them grouped at the Territory level, I guess im getting hung up trying to figure out how to simply average two of the territories together to make 1.

If i insert an average on service level at the territory level wont i still just get an average for each individual 16 territories?

Paul

 

[lbass]

Are you saying that your territory field INCLUDES the segment, e.g., the territory field returns the following?

Seg A Territory 1

-LB

 

[ptrifile]

Each Territory has a unique identifier for each segment, yes.

so it is the following:

Seg A T1
Seg A T2
Seg B T1
Seg B T1

I have it grouped on the territory, i just do not know how to take the above example and get an average service level (which is an available field) from say:

Seg A T1 and Seg B T1.

So if i ran the report now it would show this:

Territory Service Level
Seg A T1 80.00
Seg A T2 80.00
Seg B T1 60.00
Seg B T2 60.00

My question is how do i turn the above into:

Territory Service Level
Combined T1 70.00
Combined T2 70.00

I hope that helps....i know its not easy to understand what I'm trying to accomplish through posting.

Thanks again.

Paul

 

[lbass]

Create a formula like this:

stringvar array x := split({table.territory}," ");
x[ubound(x)]

This formula would always return the last part of the field, whether it ended in T1 or T100. Then insert a group on this formula and then you can insert summaries on the service level field.

-LB

 

[ptrifile]

Thanks Lbass, still not getting the desired results. I am still not getting a combined average of seg a T1 and Seg b T1.

I inserted a group on the formula and then inserted summaries and this is now my result:

t1 100
t2 0
t3 80
t4 0
t5 100
t6 61.11
t7 50
t8 77.78
t1 0
t2 0
t3 0
t4 100
t5 100
t6 50
t7 66.67
t8 83.33

What I'm trying to accomplish would be to have the result be as follows:

t1 50
t2 0
t3 40
t4 50
t5 100
t6 55.55
t7 58.33
t8 80.83

thanks

Paul

 

[lbass]

This tells me you have some outer group. Try grouping ONLY on the formula I gave you.

-LB

 

[ptrifile]

You are correct! It is now working perfectly! once again, thank you for all of the help!

Paul