My designer doesn't appear to support math functions in multi-row formula tool

[Mond]

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()

[gabrielvilella · Accepted 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.

[Mond]

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.