NORMDIST

[NoahNathan]

Is there an ability to query the cumulative normal distribution from the Z score - much like =NORM.S.DIST(2,TRUE) does in Excel?

Either an In-DB and/or function would be perfect!

[linhtran710]

Hi Patrick, 

I tried to installed by copying all the dll and xml files into my Formula Add In as the install.bat and Analytics App didnt work for me. However, it still gave me the error" Building custom formula functions using a DLL is not available on AMP yet (Expression #2). Can you advise my case ?

[patrick_digan]

Hi @linhtran710! The NormDist (and all other C++ functions) are not yet compatible with the AMP engine. For any workflow that you want to use NormDist, you'll need to ensure that AMP is off (uncheck the box). AMP may support C++ functions in 23.2 according to the latest update back in March.

[linhtran710]

I unchecked the AMP, but the formula only works with syntax NORMDIST(X). When I use the full formula NORMDIST(X, 0, 1, 0), it had unknown var type error at NORMDIST. Is there anything I could do ?

[patrick_digan]

@linhtran710 Sorry for the delay, what version of alteryx are you using? 23.1.1.123 had a bug at launch (TDSL-4785), but they fixed it via Patch1 (23.1.1.200). If you're on 23.1.1.123 (and can't/don't want to patch), you can multiply arguments by 1.0 like normdist(x,0*1.0,1*1.0,0*1.0). I'm not sure if that last one needs multiplied, but definitely the 1st and 2nd numbers.