I read a lot of the forums on counting and tried a couple ideas and read my crystal report books, but I still can't grasp this. I am making a Solicitation Status Report they want to see 8 columns three being labels such as Gift Level, Gifts Needed, Prospects Needed (yes I had to do formulas for each one). The other columns are Prospects Confirmed, Solicitations Pending, Value of Solicitations Pending, Number of Gifts Expected, Value of gifts Expected, Number of Gift/Documented and Value of Gifts Documented. I grouped on Gift Level. I have the first 4 columns but I can't count on the Amount Asked (Solicitation Pending). I figure if I can get this column I should be able to figure out the rest (with luck). Thanks for any help.

I read a lot of the forums on counting and tried a couple ideas and read my crystal report books, but I still can't grasp this. I am making a Solicitation Status Report they want to see 8 columns three being labels such as Gift Level, Gifts Needed, Prospects Needed (yes I had to do formulas for each one). The other columns are Prospects Confirmed, Solicitations Pending, Value of Solicitations Pending, Number of Gifts Expected, Value of gifts Expected, Number of Gift/Documented and Value of Gifts Documented. I grouped on Gift Level. I have the first 4 columns but I can't count on the Amount Asked (Solicitation Pending). I figure if I can get this column I should be able to figure out the rest (with luck). Thanks for any help.

What do you mean by count on the amount asked? Are you trying to figure out the total amount asked from all their assignments?

I want to count them if they meet the gift level criteria. So if they are 10,000,000.00 then count how many. At this point I have written a formula saying if >=10000000 then $10,000,000+ and I am trying to count that but no success so far.

For counting, you want to have a field or formula that contains a unique identifier (e.g., solicitation id) or null. That allows you to do both a count and a distinct count. An inferior method is to have a formula that produces 1 or 0 and then sum the formula. This is inferior, because it only allows you to do a count; not a distinct count.

Drew

I really don't understand. I might be frustrated based on I have been working on this for days. In the formula I put: Count({CnPrProp_1.CnPrProp_1_Amount_Asked}, {CnPrProp_1.CnPrProp_1_LINK}) and I get an error.