L
Lan Hoa Ha
Hi there,
I believe there are something wrong with some particular calculations in
Infopath as follows:
One form includes a repeating table with 3 columes: field 1 at colume 1,
field 2 at colume 2, field 3 at colume 3. When value in field 1 multiplies
with value in field 2 and the result is in field 3, sometimes the results are
not consistent in the places of decimal:
Field 1 * Field 2 Field 3
(1) 2.49 * 4500 = 11,205.000000000 and
(2) 2.47 * 4500 = 11,115
(3) 2.49 * 3000 = 7,470.000000000 and
(4) 2.49 * 1000 = 2490
As you see in the (1) calculation, can you please explain me why how come
this could give a result with ".000000000" while the (2) gives no decimal?
Hope you see my point. The same thing happens for the (3) and (4). Please
also be noted these figures: 2.494, 3.49, 2.499, 2.99 also generate result
with nine decimals when multiply with 4500 or 5000 or 7000 or 9000...And they
give no decimal when multiply with 4900, ...???
Just to give you more background: all the three fields here are formated as:
Data type: Decimal (double)
Decimal format: Number
Decimal places: Auto
Use a digit grouping symbol: checked
.......
Please kindly have a look at this and reply to us at your earliest
convenience.
Many thanks !
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...fe7-5be42d5792e8&dg=microsoft.public.infopath
I believe there are something wrong with some particular calculations in
Infopath as follows:
One form includes a repeating table with 3 columes: field 1 at colume 1,
field 2 at colume 2, field 3 at colume 3. When value in field 1 multiplies
with value in field 2 and the result is in field 3, sometimes the results are
not consistent in the places of decimal:
Field 1 * Field 2 Field 3
(1) 2.49 * 4500 = 11,205.000000000 and
(2) 2.47 * 4500 = 11,115
(3) 2.49 * 3000 = 7,470.000000000 and
(4) 2.49 * 1000 = 2490
As you see in the (1) calculation, can you please explain me why how come
this could give a result with ".000000000" while the (2) gives no decimal?
Hope you see my point. The same thing happens for the (3) and (4). Please
also be noted these figures: 2.494, 3.49, 2.499, 2.99 also generate result
with nine decimals when multiply with 4500 or 5000 or 7000 or 9000...And they
give no decimal when multiply with 4900, ...???
Just to give you more background: all the three fields here are formated as:
Data type: Decimal (double)
Decimal format: Number
Decimal places: Auto
Use a digit grouping symbol: checked
.......
Please kindly have a look at this and reply to us at your earliest
convenience.
Many thanks !
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...fe7-5be42d5792e8&dg=microsoft.public.infopath