Calculation Avr.Abs.Dev

[Pascal_R]

Hi Alteryx Community Team,

Anyone any idea how to translate below excel formula for the Avr.Abs.Dev?

Please see attached dataset where I try to calculate it but so far I got another result in excel...

=ROUND(AVEDEV(Wk1:W26);1)

Best regards,

Pascal

[atcodedog05]

Hi @Pascal_R 

AVEDEV was a new function to me hence i took reference from this blog.

https://exceljet.net/excel-functions/excel-avedev-function#:~:text=The%20Excel%20AVEDEV%20function%2....

I am following the calculation and getting values yours in excel.

1. Convert weeks columns into rows using transpose

2. Using summarize to get average

3. Using append tool to add average as a column

4. In formula calculate abs difference (deviation)

5. Use summarize to find avg of deviation.

Hope this helps 🙂

[mceleavey]

HI @Pascal_R ,

I've built this in the attached workflow. 

If you're looking for the standard deviation then there's a function for it on the Sum tool.

You'll then need to calculate average.

M.

M.