Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
arildomota
New Contributor

How Get a Poisson Value

Hello everyone,

I have a problem to solve, but I can't solve:

I Have a Table with the values

ID    |  #PARTS USED IN YEAR  |  # PARTS FOR LEAD TIME  7 DAYS |

P1                    624                                            11,97

P2                      15                                            0,29

P3                    145                                            2,78


With the POISSON formula in excel =POISSON(10;11.97;TRUE) I get that value 35,07%

=POISSON( NUMBER DELIVERED OF PARTS ; PARTS FOR LEAD TIME  7 DAYS;TRUE)

The result is a number of parts (10) that I need to deliver to have an availability of the 35,07%


And I have a variable vAvailability that I input the Availability goal that I wish.


Ex: If I wish a minimum 95% of availability, I must delivery 18 Part Numbers

=POISSON(18;624;TRUE) = 96,34%


I looking a formula that give me the number of parts I need to maintain the availability up to vAvailability variable.


* PARTS FOR LEAD TIME  7 DAYS =  624 / ( 365 / 7 )



1 Reply

Re: How Get a Poisson Value