Hello. I have skus and I want to know average over a period of dates. However, in some dates skus don't exist so there is no entry so I think the average doesn't count these days. How can I get the average counting NA days as 0 sales days?
1 answer
Zn([FieldName]) will replace blanks with Zeros