problem with running total need help 1

[fsreport]

ms sql
cr 9.0
i have a running total that gives me a number
and i have a summary that need to be divided by this running total.
ex:
count amount
2 100
i need to have the amount divided by count
the summary is a sum(gross_amount,contact_id)
my running total is
distinctcount(contact_id)
evaluated on each record
reset on change of contact_id

how can i get this done??????????


fsreport

 

[lbass]

Your running total will always return a one, since you are resetting it on the field you are doing a distinct count of. Once you correct the running total, create a new formula:

sum(gross_amount,contact_id)/{#yourrunningtotal}

It is also unclear why you are using a running total for your distnctcount. You can probably just use another inserted summary.

-LB

 

[fsreport]

thanks -LB
I did not have all the detail it's for a co-worker
i told him to sign up at tek-tips.
thank's a million


fsreport