VAR in Reports

L

Larry G.

I have 4 fields that are in a reports Replicate1, Replicate2, Replicate3 and
Replicate4. I need to get the Variance of all 4 fields. When I enter
=VAR(Replicate1, Replicate2, Replicate3, Replicate4) I get and error that
says I have the incorrect number of variables.

Is there a way to process this value?
 
D

Duane Hookom

Normally, your table structure would be normalized so you would be
aggregating across records and not across fields. If you can't normalize the
structure, you could try create a normalizing union query to allow you to
calculate a single field across multiple records.
 
Top