Java script for changing categories into percentages

Follow

Will Dobson

• September 24, 2014 08:28

Please help! I need to change 5 categories into a percentage in a calculation field. I have 5 fields with a yes/no/NA answer and need the yeses automatically converted into a percentage excluding the N/A answers at the bottom. I can then use this data through Globiflow to create team averages on the answers across the organisation each week. I don't know anything about Java at this time (although am keen to learn). Any help would be massively appreciated.

0

• 

  Charl Henning

  • December 08, 2014 12:57

  Hello Will
  I have a similar problem and was wondering if you found a solution to the percentage calculation issue? If so and if you are willing to share that with me I would greatly appreciate it.

  0

  Comment actions Permalink
• 

  Yohan Hidalgo

  • November 11, 2015 18:04

  Having the same issue here..

  a = 200
  b = 25%

  Math.ceil((a*b)/25,0)*25

  How can I multiply a times b, when b is a percentage integer. what should I multiply by instead of 25%?

  Thanks!

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • November 11, 2015 20:05

  Hi Yohan,

  is b the "content" of a category option (= a string)? E.g. if you have a category field with options like 10%, 20%, 25%, 30%.
  And do you want a) to multiply 200 * 25 = 5000, or b) to get 25% of 200 = 50?

  If b is a string, you can do for a):
  a = 200
  b = @category field
  c= parseInt(b.replace(/%/,""),10)
  Math.ceil((a*c),0)

  for b):
  Math.ceil(a*c/100)

  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.