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