Open Manage | Database | fields, define a field of type summary and select standard deviation of Field A as the options for this summary field.
That doesn't solve what I need. I need the Standard Deviation based on FieldA but the break field should be FieldB. Sort of like the getsummary calculation function: getsummary(fieldA;fieldB). The only thing I dont want to do is sort to get the STDev.
Hope that makes sense.
You indicated "found set is by field B"
If the only records in your found set are for this group of records, then this does exactly what you want.
Get Summary will work, but you have to group the records by Field B and this requires sorting. You can also put the summary field in a sub summary part "when sorted by Field B" and obviously, this also requires sorting.
If you can't sort the records, you'll have to use a relationship. This can be from a different table with one record for each value in field B or in a self join by Field B to the same table. Either way, there's are aggregate functions StDEV and StDEVP that can be used to compute the standard deviation of the related records.
Thanks, I completely spaced the relational part of it all. It worked. I appreciate the help.