Heres hoping someone can assist. I have been at this for toolong and giving up.

 

I have quite a complex report which sums data into totals on a group.

I have the following formula's in the detail section.

{Primary} If x (type) = primary then y (an amount is returned here)

Preprimary - if x = preprimary then y

High - if x = high then Y

 

I then have a group by company

 

I sum myabove fields ( primary column, preprimary and secondary) - this is on my group footer - I have tried it on header aswell

 

Then I have another 4 fomula's per type which I've placed on the group footer

If primary is <1 then nonpaying

if Primary in 1to500 then R500 bracket

if primary in 501-1000 then 1000 bracket

if primary >1000 then 1001 bracket

 

Now I want to count how many companies are non paying for primary, preprimary and high etc

 

I have tried running totals, sum's etc but it keeps saying this field cannot be summarised

I have placed the totals on the report footer but still nothing

 

I have created more formulas - if amount > 1 then 1 else 0

and then tried to sum that - but it says summary not allowed

 

I tried a running total putting the formula in evalute still no luck

 

Really appreciate some help

 

Thankyou

 

I

Really do appreciate the help