Calculated Field - #Div/0!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform that is dividing two different fields and creating a
percentage. The value in my subform appears as 9.05%. This field fomat
value is set to Percent. The field name is [Perc of Maturation].

I transfer this field to the main form by creating a text box. The control
setting for the text box states: =Reports!rptTPT!rptMat_Exp![Perc of
Maturation] and I'm formatting it as a Percent, when the report runs the
field on the Main Form appears as #Div/0#.

I'm just copying the field value, I don't understand why it's coming up
this way.

Any help will be greatly appreciated.
Thanks!!
G. Wolfe
 
Why not just put the same division calculation on your form? When you need
a calculated value, just recalculate it.
 
I tried your suggestion and received the same result. #Div/0!. Here's an
example of the values that are being calculated.

$2063.00/$22,790.00=.09052215

I then multiple the value by 100 to receive 9.05% or I can set the format
of the field to percent and the value changes to 9.05%.

Any other suggestion?

Rick B said:
Why not just put the same division calculation on your form? When you need
a calculated value, just recalculate it.


G. Wolfe said:
I have a subform that is dividing two different fields and creating a
percentage. The value in my subform appears as 9.05%. This field fomat
value is set to Percent. The field name is [Perc of Maturation].

I transfer this field to the main form by creating a text box. The control
setting for the text box states: =Reports!rptTPT!rptMat_Exp![Perc of
Maturation] and I'm formatting it as a Percent, when the report runs the
field on the Main Form appears as #Div/0#.

I'm just copying the field value, I don't understand why it's coming up
this way.

Any help will be greatly appreciated.
Thanks!!
G. Wolfe
Click to expand...
Click to expand...
 
Back
Top