Hello,
I have a data set with 100 materials and with the corresponding number of pieces on a daily base. Now I want to calculate the stdev on a monthly base for each material. Problem is, that not for each month a data set exists (s. example row 1).#
Can the formular be fixed?
Stdev(aggr(sum(pieces), [Material], [Month]
1. row: Stdev of 26,904 in Qlik with missing data sets for Apr, Jun, Aug and Oct.
2. row: Stdev as it should be 24, 772 with "0" instead od NULL
![marc_qlik_0-1626443043241.png marc_qlik_0-1626443043241.png](https://community.qlik.com/t5/image/serverpage/image-id/58747i044471484B9EEB16/image-size/medium?v=v2&px=400)
Thank you