General

Re: Price/Total Errors

Jimmy — Tue, 11 Feb 2014 16:47:31 GMT

Well, what's the datatype of the field? Does it have any validation rules?

Re: Price/Total Errors

cartotech81 — Mon, 10 Feb 2014 14:25:50 GMT

When I set to 2 decimals the same field still shows up with the red box due to invalid data, but I am not sure what makes it invalid.

Re: Price/Total Errors

Jimmy — Mon, 10 Feb 2014 00:43:08 GMT

One alternative formula you could try is:

round((@itemPrice * @itemQuantity) * 100) div 100

That might give you better luck in terms of the trailing digits. Could you clarify what you mean when you say it "still errors on invalid data"? What invalid data are you referring to?

Price/Total Errors

cartotech81 — Wed, 05 Feb 2014 22:02:05 GMT

Currently I have a form that a user will enter a price and quantity and then it will calculate the total cost.

For the most part it works perfectly fine, but for some reason when anyone enters a price that ends in .95 the total column adds a lot of 0's after the correct total. I also have a second total that totals the totals and it calculates fine.

When I try and set my currenct from auto to 2 decimals it does show the correct total but still errors on invalid data.

Any ideas the formula I am using in the value is round((@itemPrice * @itemQuantity) * 100) * .01