Calculating Percentile in Quickbase

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Acknowledged
Hi, I m looking for Percentile Calculation in one of my quickbase application, similar to the example provided in the below link:
http://www.dummies.com/education/math/statistics/how-to-calculate-percentiles-in-statistics/
Photo of JW

JW

  • 140 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
If you make a summary report and show a column for the value shown "normally" and then have the same column show "as a running % down the column", then that second column will be a Percentile.
Photo of JW

JW

  • 140 Points 100 badge 2x thumb
I have 11 fields in a table, the user inputs $ amounts in those fields. And upon input i need to figure out a way where the system calculates nth percentile using the steps provided in the link. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
That will require non native custom scripting.
Photo of JW

JW

  • 140 Points 100 badge 2x thumb
Is there a way where we can accomplish such type of functionality. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
Yes, you can hire a Quick Base Solution Provider (QSP) to write that code for you.  I don't do that work myself, but I can recommend some QSP shops for that. Contact me via at QuickBaseCoach.com and I can communicate directly with you.