Rolling 6 month sum/average returns incorrect values when current months values is Zero
Hi, I am having problem calculating Rolling 6 month sum and average if the current months value is Zero. For sum it returns 0 and for average it returns a null. Is there any option that I could use to make the set analysis to consider zero values? Thanks!