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.

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.

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    so what is the gap between what you're getting and what you want?

    "it's not doing what i need it to do..."