I hope someone can help me.

I am creating a report based on donors giving to an area.  I need to count how many donors have;

A) given only to the area the report is based on

B) Given to only other areas

C) given to the area and any other area.

The problem I am having is the information on the area is listed in one field so I can’t use a simple Boolean formula to exclude or include donors.

The information looks like this

Donor   Area

2010       Cat

                Cat

                Dog

                Horse

2011       Cat

                Cat

                Cat

2014       Dog

                Horse

                Rat

I have successfully pulled the area information into an array and can use the array to look for Either A,B or C.  But I then can’t do a count of how many are A,B or C.

How can I get around this issue.  The way our data is set up I am going to run into this situation often so I am keen to find a solution.

Thanks everyone.

Ok so this is how I currently have things setup

My data is grouped by Customer and then Fund category.

I have three formulas,

In Group header 1 - Initiate Array

Shared numberVar x:=1;

In Group Header 2 – load Array

Shared numberVar x;

Shared StringVar array fund_Category;

if not({GfFnds_16Fn.GfFnds_16Fn_Fund_category} in fund_Category ) then  //checks to see if already in array

( 

    x := x + 1;                                                            //This is where the values are added to the array 

    redim preserve fund_Category[x]; 

    fund_Category[x] := {GfFnds_16Fn.GfFnds_16Fn_Fund_category}; 

); 

fund_Category[x]; 

In Group Footer 1 – Print array

Shared stringVar array fund_Category;

Shared Stringvar all_Categories;

all_Categories := Join (fund_Category, ","); // Use Join function to print array on one line

mid(all_Categories,2);

 From here I can determine if a donor is one of the three categories with a simple this then else formula, but I can’t sum (total) how many donors are in each category. 

This report is in the early stages so I am more than happy to scrap what's been done so far and start again if it will work.

Thanks in advance