Math Operations

A

Alex

Hi,

I have 4 data fields namely: A, B, C, and D. All whole numbers except for D
(Double Decimal)

I made a formula in the DATA Properties Tab of data field D, in the Value
field looking like this: A*B/C.

Everytime I preview the form, D always displays "NaN" and data field D will
only calculate when I click on TAB after entering a value in data field C.

Is there a way to avoid the "NaN" from showing up and for the field to
auto-calculate and update as I enter values in A, B, C w/o the need to press
TAB button at data field C?

Thanks. Appreciate your help.
 
K

Kalyan G Reddy MVP (GGK Tech)

Hello
NaN will be shown when the value is set as default value
If you use a rule and put an action as set fields value using this formula
then you can avoid the NaN. Otherwise it will look for the default value.
 
B

B.Shiva Prasad

Hi Alex,

NaN will not shown with all default values, NaN will show when the output is
exceptional data or wrong data. Text box will take "0" as default value so in
your formula (A * B / C), B / C --> 0/0 has no value thats why it is showing
NaN. put the rule on the text box C that C is not blank then set the formula
on text box D you will get the result.

B.Shiva Prasad/ http://www.ggktech.com
 
Top