Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross Tab calculate avg

Status
Not open for further replies.

ksaab2002

MIS
Jan 6, 2005
66
0
0
US
Hi,

I am using CR10 and SQL 2005. I have a cross tab with:
Rows: {@category}
[which is a formula resulting in a 3 range series (1-5, 6-10, 11 or more)]

Cols: Table.costctr
[Field which contains a cost center number]

Summarized Fields: Sum of @count and
Sum of Table.Spend

[where {@count} is a count formula for transactions that removes voided transactions, etc (if x then 0 else +1)//// Spend is a dollar amount per transaction]

May be a dumb question, but how do I get the AVG of:
Sum of Table.Spend/Sum of @count

to show up in the summarized fields section instead?

Thanks,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top