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
You can use for one field:
100 minus the sum of the other 2 fields.
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?
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.
Copy link to clipboard
Copied
You can use for one field:
100 minus the sum of the other 2 fields.
Copy link to clipboard
Copied
That's worked for most of the values. for now this can be the solution.
Thanks
Copy link to clipboard
Copied
In your "PT1" field you used same field name for both variables.
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.
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.
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.