SidCharming
Technical User
I have four columns, they contain sizes. I want to perform calculations of Average, Standard Deviation, Min, Max and count all three together.
example:
[tt][teal]
size1 size2 size3 size4
----- ----- ----- -----
1 4 2 3
7 12 3
10 2
2
7 3 2
9 2
6 3 2[/teal][/tt]
My intent is to have all information needed contained in the report query... not have an external query. Or better yet, can I do something with code for this?
Currently I perform the calculations on each column, but still have to export the columns to Excel and do the calculations long hand for all data in the four columns.
Sid from Minnesota
example:
[tt][teal]
size1 size2 size3 size4
----- ----- ----- -----
1 4 2 3
7 12 3
10 2
2
7 3 2
9 2
6 3 2[/teal][/tt]
My intent is to have all information needed contained in the report query... not have an external query. Or better yet, can I do something with code for this?
Currently I perform the calculations on each column, but still have to export the columns to Excel and do the calculations long hand for all data in the four columns.
Sid from Minnesota