VAR in Reports

[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?

 

[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.