AnsweredAssumed Answered

Calculating percent rank

Question asked by jdc on Oct 22, 2012
Latest reply on Feb 5, 2016 by AllegroDataSolutions

How do you calculate percent rank in FM with some requirments:

  1. Dynamic calculation as data is entered or imported
  2. Duplicate numbers have same percent rank
  3. Zero value has 0% (percent rank)
  4. Results in same value as excel's function
  5. Calculated for individual month within yearly data (for example January would have a ranking of expenses, February ranking, etc)

Thanks for any help provided