Field Calculation Problem

[evan_panagiotopoulos]

I have a form with four numeric fields. Based on the user entry I calculate an average on a fifth field. How can I show the final average only when all four fields are filled? I try to do the following but it creates a circular reference:

if (isvalid(field1) and isvalid(field2) and isvalid(field3) and

isvalid(field4),

Round(Average(READING ACH 1, READING ACH 2 , READING ACH 3 , READING ACH 4), 2), xoxoxoxoxox )

In the place of xoxoxoxoxoxo I want to display nothing in the field.

Thanks for the suggestions.

Evan P.

[LiveOak]

Wrong function:

if (notIsEmpty(field1) and notIsEmpty(field2) and notIsEmpty(field3) and notIsEmpty(field4), Round(Average(READING ACH 1, READING ACH 2 , READING ACH 3 , READING ACH 4), 2), "" )

-bd