Highlighted

Totalling of percentage doesnot come to 100%

Contributor ,
Sep 01, 2020

Copy link to clipboard

Copied

I have  3 rows in which % is calculated of the total ... but some how the total of the 3 fields doesnot come to 100% . in some cases it totals correctly but when all the 3 fields have equal value their % of the total show 33% each which doesnot add to 100%..... below is the screenshot.. and  also the link of the working file.  Link to the working pdf file:  https://www.dropbox.com/s/n49e6ta3xb3dlf5/Page%201%20GMS%20Form.pdf?dl=0

 

Thanks percentage error.png

Adobe Community Professional
Correct answer by Bernd Alheit | Adobe Community Professional

You can use for one field:

100 minus the sum of the other 2 fields.

TOPICS
Acrobat SDK and JavaScript, PDF forms

Views

63

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Totalling of percentage doesnot come to 100%

Contributor ,
Sep 01, 2020

Copy link to clipboard

Copied

I have  3 rows in which % is calculated of the total ... but some how the total of the 3 fields doesnot come to 100% . in some cases it totals correctly but when all the 3 fields have equal value their % of the total show 33% each which doesnot add to 100%..... below is the screenshot.. and  also the link of the working file.  Link to the working pdf file:  https://www.dropbox.com/s/n49e6ta3xb3dlf5/Page%201%20GMS%20Form.pdf?dl=0

 

Thanks percentage error.png

Adobe Community Professional
Correct answer by Bernd Alheit | Adobe Community Professional

You can use for one field:

100 minus the sum of the other 2 fields.

TOPICS
Acrobat SDK and JavaScript, PDF forms

Views

64

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Sep 01, 2020 0
Adobe Community Professional ,
Sep 01, 2020

Copy link to clipboard

Copied

The result of the calculation at the rows is 33.33333333

The rounded value is 33.

Want you a 34 at one one of rows?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 01, 2020 0
Contributor ,
Sep 01, 2020

Copy link to clipboard

Copied

yes, whenever there is deficit  in adding of the 3 fields .. it should adjust one of the fields so as the total comes to 100. Also if the 3 fields adds to more than 100 then also it should adjust one of the fields so as the total comes to 100.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 01, 2020 0
Adobe Community Professional ,
Sep 01, 2020

Copy link to clipboard

Copied

You can use for one field:

100 minus the sum of the other 2 fields.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 01, 2020 0
Contributor ,
Sep 01, 2020

Copy link to clipboard

Copied

That's worked for most of the values.  for now this can be the solution.

 

Thanks

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 01, 2020 0
Engaged ,
Sep 01, 2020

Copy link to clipboard

Copied

In your "PT1" field you used same field name for both variables.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 01, 2020 0
Contributor ,
Sep 01, 2020

Copy link to clipboard

Copied

@NesaNaurani..... i don't think PT1 field is the issue......   issue here is the total of 3 fields.. it should be 100 all the time......   just focus on 3 fields not on PT1. PT1 has nothing to do with the 3 fields . it is there just for showing 100.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 01, 2020 0
Contributor ,
Sep 01, 2020

Copy link to clipboard

Copied

What is the point of PT1 field? If you divide it by itself you will always get 100%? you can just write 100% and doesn't need script for that.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 01, 2020 0
Contributor ,
Sep 01, 2020

Copy link to clipboard

Copied

here PT1 field is not the issue... issue is the 3 fields should total 100% all the time....... if it is not .. one of the fields should be adjusted so as the total comes to 100.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 01, 2020 0