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