I am trying to use the SQRT, SUM, and POW functions but i'm getting the following results message. What can I do to get these formulas to work? I got Average() to work but not AVG()
Solved! Go to Solution.
Does your company uses this add-in? https://community.alteryx.com/t5/Engine-Works/An-Overview-of-the-Alteryx-Abacus-Add-In/ba-p/398982
This error is usually when you use a formula that is not in Alteryx by default. You can install the add-in, or just use another combination of formulas/tools that gets to the same result.
Thanks! I’ll check around if we can use the plug-in… is there any other way to calculate a rolling 20 period standard deviation? I can only think of using the multi row formula.