Six Sigma score calculation in ETL
Hi,
I'm trying to calculate the six sigma score in ETL, the excel formula is =NORMSINV(1(((Errors/Total records)*1000000)/1000000))+1.5
I found a Redshift function CUME_DIST but it doesn't do what I need. Any inputs to achieve this is much appreciated.
0
Comments

NORM.S.INV() ... I believe is just the inverse of the CUME_DIST() function that you found in redshift.
I'm not sure why your formula is adding 1.5 to the end either.
0 
so what is the gap between what you're getting and what you want?
"it's not doing what i need it to do..."
0