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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

DSGunner
DSGunner
Offline

Badges

Badges
5

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts

Posts
6

Discussions

Discussions
0

Questions

Questions
6

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by DSGunner
Customize the badges you want to showcase on your profile
Re: Adobe LifeCycle ES2 rounding up formula numeric value - Adobe LiveCycle 21-01-2016
We have a WINNER!! Thanks very much. That works as expected, the only slight problem it may cause is for example: If I select 8no 3's, 1no 2's and 3no 1's. The calculation has added them all up to get 29 then divided by 12 to get 2.4 and so doesn't round up. However when you look at the sheet there are more three's than any other score so having the average score as 2 appears to be wrong, even though the calculation is correct. I'm not sure how the user wants it to appear so this may be fine but...

Views

456

Likes

0

Replies

0
Re: Adobe LifeCycle ES2 rounding up formula numeric value - Adobe LiveCycle 20-01-2016
I've just taken all the radio buttons out of the sub forms and the formula just works as it did without the round up function added. Any ideas?

Views

460

Likes

0

Replies

0
Re: Adobe LifeCycle ES2 rounding up formula numeric value - Adobe LiveCycle 20-01-2016
I've just changed the forumla to quickly include only 3 of the radio button values and have divided by 3 instead of the usual 12. I've then take the radio forms out of the sub-form to match the RBQ1 setup. This does something different but it's even more random in the way it rounds up. I've selected 1 for all 3 questions and the average is down as 2. I think select 1 and 1 and 6 and it comes back with an average score of 7.

Views

454

Likes

0

Replies

0
Re: Adobe LifeCycle ES2 rounding up formula numeric value - Adobe LiveCycle 20-01-2016
I've customised each radio button to have a value of 1-6. I've gone through the menu's and cannot see anything that says 'null value' anywhere. The default value on them all is 1 unless the user selects another value. A screen shot of the form is below if that helps at all.Regards

Views

455

Likes

0

Replies

0
Re: Adobe LifeCycle ES2 rounding up formula numeric value - Adobe LiveCycle 20-01-2016
Hi Magus,Thanks for your reply. I've just tried that but it's the same as it was before. I have to click on 9no 2's before it changes the average score from 1 to 2. I would expect the average score to change from 1 to 2 on the 7th questions as at that point there are 7 questions with a score of 2 and only 5 questions with a score of one.Regards

Views

457

Likes

0

Replies

0
Adobe LifeCycle ES2 rounding up formula numeric value - Adobe LiveCycle 19-01-2016
I've used ES2 to create a user entry form. On that form there are 12 questions and each question has a radio button with a scoring system from 1 to 6 on it. The user is asked to select a score from the radio button for all 12 questions and then at the bottom the form gives an average score. This all works great but the score doesn't round up to the nearest whole number so it's not as accurate as I would like it to be. Could anyone give me any pointers as to ways of fixing this issue? I have no e...

Views

1.4K

Likes

0

Replies

10