Calculating Wrong

Avatar

20-12-2008

I have an odd problem. I have an order form with a flowing table. The data is binded and everything flows correctly. At the bottom of the form, I have created totals for various columns. This seem to be working fine. I wanted to create a field to show how much the customer is saving. I created the appropriate field to compare the savings, but it always takes off like one penny for each field. I've checked it over and over and can't find anything wrong. Help!

Replies

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

22-12-2008

Post your form and a brief description of how to duplicate the problem to livecycle8@gmail.com and I wil have a look at it.

Avatar

22-12-2008

I figured out what was going on. My data source had 3 digits past the decimal. It was overriding the numeric field patterns. I could not get it to round, so I went back to the XML data and took the third digit off. It was a little time consuming, but fixed the problem. I know there's a way to make the program round, but I couldn't get that to work. This work-around was okay.



Thanks!