S
Stuart
Good Morning!
I have a form that the user inputs data on. There are a
number of calculated fields. The numbers for the
calculations come from two different places on the form,
general information and line specific informaion. All the
calculated fields have 0.00 in them as soon as I type the
general informaion in the begenning of the form. What I
need is the 0.00 to be blank(or null) so on my report when
I calculate averages, the blank or null fields are not
included in the average calculation. Noe the 0.00 celss
are included int eh average calculation and really skewing
the results. Thank you for your help. -Stu
I have a form that the user inputs data on. There are a
number of calculated fields. The numbers for the
calculations come from two different places on the form,
general information and line specific informaion. All the
calculated fields have 0.00 in them as soon as I type the
general informaion in the begenning of the form. What I
need is the 0.00 to be blank(or null) so on my report when
I calculate averages, the blank or null fields are not
included in the average calculation. Noe the 0.00 celss
are included int eh average calculation and really skewing
the results. Thank you for your help. -Stu