Poisson function
My customer needs to calculate the POISSON cumulative results to find out the lambda value that goes above a probability treshold.
In a maintenance use case, this is useful for him to statistically determine given a target service level and the past average of incidents how many incidents should occur in the future, and therefore calculate the associated costs.
Excel has a builtin function to perform this calculation, and a specific iterative algorithm since 2003 to manage the calculation even for big numbers.
See the article below for further details and attached spreadsheet as an example:
https://support.microsoft.com/enau/help/828130/excelstatisticalfunctionspoisson
It would be helpful if that kind of statistical function would be available out of the box in Anaplan!
Comments

Status changed to: New0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!