VAR in Reports

  • Thread starter Thread starter Larry G.
  • Start date Start date
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?
 
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.
 
Back
Top