Crystal Reports Summing groups

Message

   Hi Hilfy,

Thanks fro your response & suggestions.
In implementing what you put forward, I came across what I feel is the crux of the problem here. It's in the 

If left({table.OrganizationName}, 2) = 'IS' then {detail table.count} else 0

conditional.

For some reason, my code completely ignores this. It never choses it, even though I've tested the string to be 'IS' when manipulated (by displaying it).

I'm currently putting this in a formula as suggested. I've tested the formula to return a simlpe value "7" for example. That works fine, but when I create a global variable, & increment it in the "If" conditional above , it returns 0. Why would this be the case.  Even if I create a simple globalVar := globalVar + 1; globalVar;  it always returns 0. 

Shouldn't this increment for every row in each group that starts with "IS"?

Thanks very much for your thoughts on this

Ant