Expand my Community achievements bar.

LiveCycle - Calculation issue

Avatar

Former Community Member

Simple task, not so easy to figure out.

How do I write the script?

If 1 table cost $15.00 and they have 2 entered, how do I get the grand total to calculate the total dollar value, in this case s/b $30.00?

8 Replies

Avatar

Level 6

Place this script in the field that will display the total:   fieldname * 2

replace fieldname with the name of the field on your form

Avatar

Former Community Member

Paul,

Thank you so much, this helped. Is there a way to incorporate the decimal point in the value, 15.00 vs. 15? If not, this works too.

Tina Dravecky Ι Marketing Ι Direct No.: 224-361-2229

Avatar

Level 6

Absolutely.

Click on the field and look at your "palettes" on the right side of the program.  There is a tab labeled Field.  Click that tab.  Now you have options of how you want that field to look.  There is a drop list named "Display."  Click it and select the display pattern:  $Z,ZZ9.99

Avatar

Former Community Member

Unfortunately it didn't work. I followed the instructions, but the PDF view does not show the pattern selected. Hum.

Tina Dravecky Ι Marketing Ι Direct No.: 224-361-2229

Avatar

Level 6

Leave what you did and try this:  Click on binding tab and in the data format drop list select decimal

Avatar

Former Community Member

Hum. I only have Float and Integer available, no decimal option.

Tina Dravecky Ι Marketing Ι Direct No.: 224-361-2229

Avatar

Level 6

Check your private messages under Your Stuff.  I'll take a look at the form if you'd like