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.
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.
so what is the gap between what you're getting and what you want?
"it's not doing what i need it to do..."