Figuring funny aggregate totals in Query

[nowanda]

I have a query which gives me a category (cat) and a value (val). I'd like to calculate a percent on the total of the values.. where :

per=val/([Total of Val])*100

cat val per
A 01 0.84
B 45 37.8
C 73 61.3

Total is 119 so per is 1/119, 45/119 and 73/119.

Ways I have tried give me aggregate errors. Sum(Val) for example.
Any tips?

Nowanda
This message was edited by nowanda on 2003-02-21 16:51

 

[Aladin Akyurek]

I have a query which gives me a category (cat) and a value (val). I'd like to calculate a percent on the total of the values.. where :

per=val/([Total of Val])*100

cat val per
A 01 0.84
B 45 37.8
C 73 61.3

Total is 119 so per is 1/119, 45/119 and 73/119.

Ways I have tried give me aggregate errors. Sum(Val) for example.
Any tips?

Nowanda
This message was edited by nowanda on 2003-02-21 16:51

Care to provide the relevant table(s) using the standard notation...

TABLE(PrimaryKey,Field1,Field2,...)

like in...

CUSTOMERS(Customer#,CustomerName,Street,City,State)