Skip to main content
rakeshk21205956
rakeshk21205956
Inspiring
September 1, 2020
Answered

Totalling of percentage doesnot come to 100%

  • September 1, 2020
  • 3 replies
  • 1356 views

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

This topic has been closed for replies.
Correct answer Bernd Alheit

You can use for one field:

100 minus the sum of the other 2 fields.

3 replies

A
Asim123
Inspiring
September 1, 2020

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.

rakeshk21205956
rakeshk21205956Author
Inspiring
September 1, 2020

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.

Nesa Nurani
Community Expert
Nesa NuraniCommunity Expert
Community Expert
September 1, 2020

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

rakeshk21205956
rakeshk21205956Author
Inspiring
September 1, 2020

@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.

Bernd Alheit
Community Expert
Bernd AlheitCommunity Expert
Community Expert
September 1, 2020

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?

rakeshk21205956
rakeshk21205956Author
Inspiring
September 1, 2020

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.

Bernd Alheit
Community Expert
Bernd AlheitCommunity ExpertCorrect answer
Community Expert
September 1, 2020

You can use for one field:

100 minus the sum of the other 2 fields.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices