Need to replicate Excel Math functions (NORMSDIST and NORMSINV) into Alteryx Workflow

[aparanjith1]

Hi All,

I am completely a new bee to Alteryx and I am working on converting the excel input into a Alteryx workflow. I came across the Math functions in Excel (NORMSDIST and NORMSINV) which I could not find in Alteryx Formula tool, but when I researched about it I came across links which are saying to download Addins from the third party (GIT) to get these Math functions into Alteryx. But, unfortunately that is not an option for me as my company does not allow that.

So, I am looking for some alternate approach where I can replicate the same in Alteryx workflow. Below is the Excel formula which I need to replicate in Alteryx;

=NORMSDIST(NORMSINV(E9)/SQRT(1-F9) + SQRT(F9/(1-F9))*NORMSINV(G4))

Can someone please help me in this?

Thanks in Advance!

[AZuc]

Hi,

Based on this link https://www.source-code.biz/snippets/vbasic/9.htm 

I've built the attached macro. 

I haven't stressed the tests. Please consider this a draft macro.

[Ewelike]

Thank you very much!

I was able to use this to implement NORMSDIST and NORMSINV.

Ewe.