Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

calculating a total

Avatar

22-01-2009

I have downloaded one of the sample forms, Purchase Order(Live Cycle ES), and have modified it to suit my needs. However, I have messed up the formulas, by deleting/changing certain cells. I can no longer get it to "total." It looks like a purchase order sheet where the end user will type in Quantity, Unit Price and the form Calculates that Amount. Then they can click on "add Item" button and type in additional items, if needed. The problem is the Total is not reflecting any activity. Is there someone out there I could e-mail the form to for review to let me know what i am doing wrong? Or is it possible to walk me through this. I am a first time user and, of course, am trying to meet a deadline to post this form on a company website. Thanks in advance.

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

23-01-2009

Why not look at the original sample again. Or you can look at other Purchase Order samples that are notdynamci interactive as they will have the same code.

Avatar

23-01-2009

Paul, thanks for your reply - I did do that and typed in the formula and I keep getting errors stating for example: accessor 'detail[*].numAmount'is unknown.



No matter what formula I put in I get some sort of error. I bought the book Creating Dynamic Forms with Adobe LIve Cycle Designer, but no place in the book, that I can find, says how to create a formula - at least not that I can understand - I am a Word user not even Excel. Perhaps I should just do a plain form that the end user will just have to total up on their own.



Thanks again.

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

23-01-2009

Send the form to livecycle8@gmail.com and I will have a look when I get a chance.

Avatar

23-01-2009

Paul,



I have sent the form to the e-mail as suggested - thanks again!!



Elaine

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

23-01-2009

I already responded

Avatar

20-03-2009

I am very new to LiveCycle, and I was hoping that I could get some help on making a dividing calculation. I need to have a field (Monthly_Payment_Sum) divide by field (Monthly_Income_Sum) = a percentage. I have tried many different variations and I don't think I am even close. Any help would be much appreciated. Thank you.

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

20-03-2009

Using javascript:



name of field to store percentage.rawValue = (Monthly_Payement_Sum.rawValue/Monthly_Income_Sum.rawValue) * 100