Hello,
I am trying to figure out how to create a sdev field on a report or in
a query that is based on a claculation of 2 fields.
I have these fields:
Number of samples--this is a calcualted field in query (counts samples
grouped by a "week" and "group" fields)
Sum of Volume--this is a calcualted field in a query (grouped by week
and group)
Avg volume--- (volume\number of samples)-calculated in a query
I am trying to get the SDev for the volume by group and week--have
tried
sdev (volume\number of samples)
but it is not working. I have alos tried to use the Sdev function on
the avg vbolume field in the query and that is not working either. I
must be missing something--can anyone help me figure this out?
Thanks
bob
If you need more info pleae let me know