• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Totalling of percentage doesnot come to 100%

Engaged ,
Sep 01, 2020 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

TOPICS
Acrobat SDK and JavaScript

Views

550

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
community guidelines

correct answers 1 Correct answer

Community Expert , Sep 01, 2020 Sep 01, 2020

You can use for one field:

100 minus the sum of the other 2 fields.

Votes

Translate

Translate
Community Expert ,
Sep 01, 2020 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?

Votes

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
community guidelines
Engaged ,
Sep 01, 2020 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.

Votes

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
community guidelines
Community Expert ,
Sep 01, 2020 Sep 01, 2020

Copy link to clipboard

Copied

You can use for one field:

100 minus the sum of the other 2 fields.

Votes

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
community guidelines
Engaged ,
Sep 01, 2020 Sep 01, 2020

Copy link to clipboard

Copied

LATEST

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

 

Thanks

Votes

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
community guidelines
Community Expert ,
Sep 01, 2020 Sep 01, 2020

Copy link to clipboard

Copied

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

Votes

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
community guidelines
Engaged ,
Sep 01, 2020 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.

Votes

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
community guidelines
Enthusiast ,
Sep 01, 2020 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.

Votes

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
community guidelines
Engaged ,
Sep 01, 2020 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.

Votes

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
community guidelines