Normdist and Norminv functions in Alteryx

areeba

Hi Team,

I have a formula in excel to calculate a column Amount. The formula is :

IF($AD7=0;"No exposure";$AE7*(NORMSDIST((1-AS7)^-0,5*NORMSINV($AA7/100)+(AS7/(1-AS7))^0,5*NORMSINV(0,999))-$AA7/100)*(1-1,5*AT7)^-1*(1+($AF7/365-2,5)*AT7))

i want to write this in alteryx. Can somebody please help me to rewrite this in Alteryx to create column Amount?

PS: My Company Alteryx designer doesn't have Predictive Analysis tool version

Regards

Areeba

Ben_H

Hi @areeba,

Do you have some sample data we can apply it to?

Out of interest wouldn't the bits I've highlighted in red always come out to 1? (unless the input values were 0) Or am I missing something? 

IF($AD7=0;"No exposure";$AE7*(NORMSDIST((1-AS7)^-0,5*NORMSINV($AA7/100)+(AS7/(1-AS7))^0,5*NORMSINV(0,999))-$AA7/100)*(1-1,5*AT7)^-1*(1+($AF7/365-2,5)*AT7))

Regards,

Ben