Calculations Using Counts in Summary Parts

[stopitsimon]

I have a field in a Sub-Summary Part that is creating a list of totals when sorted. If, for example, this list (when in Preview mode), is five totals long, how can I create a calculation that will give me a sum of only two of the totals?

For Example:

Green 5

Blue 6

Red 1

Black 2

White 2

The above totals appear in sub-summary fields when sorted by Color. I'd like to create a field that shows the combined totals of Blue and Red in a different sub-summary field.

If this were a repeating field, I could choose which repetition of the field to use in a calculation. Perhaps I'm going about it the wrong way? Is there a calculation that will give me a count of a field based on a criteria?

[Twd70]

Personally i'd add:

is_red_blue = if( colour = "blue" or colour = "red" ; 1; 0)

then do a summary of is_red_blue to count them.

Edited September 15, 2008 by Guest