Adobe Community: How do I round up a total to the nearest dollar?

Currently Being Moderated

1. BR001,

Jun 8, 2012 11:54 PM in reply to jeanette614

Report

Hi,

In JavaScript you can use the toFixed method of the number object to round to an whole number. So if variable total had a value of 10.5 then total.toFixed() would give you 11.

One catch is that toFixed() returns a string value so it might not format exactly how you expect, so

parseInt(total.toFixed())

Will return a number value.

Regards

Bruce

|

Mark as:

Currently Being Moderated

2. jeanette614,

Jun 11, 2012 9:46 AM in reply to BR001

Report

I already have a FormCalc script in that field. Here is what I have:

Table2.Row8.Eight * 6.07

And this parseInt line is Javacript.

So how would I write the whole script?

|

Mark as:

Currently Being Moderated

3. BR001,

Jun 11, 2012 3:14 PM in reply to jeanette614

Report

Hi,

The FormCalc equivilant is the Round function, so;

Round(Table2.Row8.Eight * 6.07, 0)

With the second parameter to Round being the number of decimal places, which defaults to zero so in this case you could just write;

Round(Table2.Row8.Eight * 6.07)

Regards

Bruce

|

Mark as:

Currently Being Moderated

4. jeanette614,

Jun 11, 2012 3:40 PM in reply to BR001

Report

Thank you!!!!!

Date: Mon, 11 Jun 2012 16:14:20 -0600

From: forums@adobe.com

To: jeanetteeichhorn@hotmail.com

Subject: Re: How do I round up a total to the nearest dollar? How do I round up a total to the nearest dollar?

Re: How do I round up a total to the nearest dollar?

created by BR001 in LiveCycle Designer - View the full discussion

Hi, The FormCalc equivilant is the Round function, so; Round(Table2.Row8.Eight * 6.07, 0) With the second parameter to Round being the number of decimal places, which defaults to zero so in this case you could just write; Round(Table2.Row8.Eight * 6.07) Regards Bruce

Replies to this message go to everyone subscribed to this thread, not directly to the person who posted the message. To post a reply, either reply to this email or visit the message page: Re: How do I round up a total to the nearest dollar?

To unsubscribe from this thread, please visit the message page at Re: How do I round up a total to the nearest dollar?. In the Actions box on the right, click the Stop Email Notifications link.

Start a new discussion in LiveCycle Designer by email or at Adobe Forums

For more information about maintaining your forum email notifications please go to http://forums.adobe.com/message/2936746#2936746.

|

Mark as:

Currently Being Moderated

5. jeanette614,

Jun 12, 2012 9:51 AM in reply to BR001

Report

I'm sorry to be such a dunce, but it's still rounding down and not up. If I put a quantity of one in the table and it multiplies by 6.07 the total shows as $6.00.

|

Mark as:

Currently Being Moderated

6. BR001,

Jun 12, 2012 3:12 PM in reply to jeanette614

Report

You will want to use the Ceil function instead, which returns the next whole number greater than the expression, so;

Ceil(Table2.Row8.Eight * 6.07)

Just note that this will only for positive numbers, if you have to deal with negative numbers (maybe a refund) then you will need to use the Floor function.

Regards

Bruce

|

Mark as:

Currently Being Moderated

7. jeanette614,

Jun 12, 2012 8:26 PM in reply to BR001

Report

Ok, I will try this on my form and let you know how it went. Thanks so much for your continued support.

Date: Tue, 12 Jun 2012 16:12:57 -0600

From: forums@adobe.com

To: jeanetteeichhorn@hotmail.com

Subject: Re: How do I round up a total to the nearest dollar? How do I round up a total to the nearest dollar?

Re: How do I round up a total to the nearest dollar?

created by BR001 in LiveCycle Designer - View the full discussion

You will want to use the Ceil function instead, which returns the next whole number greater than the expression, so; Ceil(Table2.Row8.Eight * 6.07) Just note that this will only for positive numbers, if you have to deal with negative numbers (maybe a refund) then you will need to use the Floor function. Regards Bruce

Replies to this message go to everyone subscribed to this thread, not directly to the person who posted the message. To post a reply, either reply to this email or visit the message page: Re: How do I round up a total to the nearest dollar?

To unsubscribe from this thread, please visit the message page at Re: How do I round up a total to the nearest dollar?. In the Actions box on the right, click the Stop Email Notifications link.

Start a new discussion in LiveCycle Designer by email or at Adobe Forums

For more information about maintaining your forum email notifications please go to http://forums.adobe.com/message/2936746#2936746.

|

Mark as:

LiveCycle Designer

How do I round up a total to the nearest dollar?

Jun 8, 2012 5:58 AM

More Like This

Bookmarked By (0)

Answers + Points = Status