Calculate Grand Total for an already summarize group formula

[oanion]

I’ve created a report that is grouped by product and date. For each product, I had to calculate the number of accounts generated on the very FIRST DATE the account was opened. I calculated this my creating a formula that used the minimum function to give me the 1st date of the account. The number of accounts generated on the first day for each product was calculated with the following formula :
count({AccountNumber},{ PlacedDate}), and placed in the group header 1 section. My problem is that I need a grand total of all the accounts opened on the 1st day for each product. I’ve found out that it is not possible to use a summary function with another summary function. How can I create the grand total of all accounts for the 1st day for each product?

This is what my data looks like now, but I cannot sum up the grand total of the accounts

Number Of
Product Accounts Earliest Date
1ST UNION MASTERCARD 251.00 8/30/2001
1ST UNION VISA 3.00 8/30/2001
ARBOR 506.00 2/20/2002
ARBOR MASTERCARD 23.00 8/30/2001
ARBOR VISA 93.00 8/30/2001
BANK OF AMERICA 869.00 9/13/2000

 

[lbass]

I think you can insert a running total into your details section. Use {table.acctno} as the field, count, evaluate using a formula:

{table.date} = minimum({table.date},{table.product})

Reset never.

You also could use a running total like this to do the count per product, resetting it on change of group (product).

-LB