Skip to main content
S
Sharla24220665deqr
Participant
April 27, 2022
Answered

Percentage format

  • April 27, 2022
  • 1 reply
  • 2917 views

The document I have has % but the format is not what we would like. How can I change the format? Currently you have to enter.10 to get 10%, we would like to just enter 10 for 10%. We will also need to change the total percentage to make sure that when they add up they equal 100%

 

Correct answer Sharla24220665deqr

try67, 

Thank you for the help. I was able to use thee code to get my % format corrected. 

 

Now I just need to firgure out how to get the total to add the above lines to get my total %

1 reply

try67
Community Expert
try67Community Expert
Community Expert
April 27, 2022

That's how the Percentage format works. If you want it to work differently then you can use your own custom Format script to do it. The code to do that is this:

if (event.value) event.value+="%";

 

Regarding the percentages adding up to 100%, that's quite tricky to do. What should happen if they don't?

    S
    Sharla24220665deqrAuthorCorrect answer
    Participant
    April 27, 2022

    try67, 

    Thank you for the help. I was able to use thee code to get my % format corrected. 

     

    Now I just need to firgure out how to get the total to add the above lines to get my total %

      S
      Sharla24220665deqrAuthor
      Participant
      April 27, 2022

       

       total percentage is show like 3,000% instead of 30%. How do I fix that? 

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