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.
