Hi,
I am using TIMESUM function with AVERAGE as aggregation method for specific from-to period. Some of the cells have the zero values in it, but this functions is considering those zero cells also into count . This gives me wrong average. How can we skip zero cells and calculate average only for non zero values with specific time period range. See attached example average of below with TIMESUM function is showing as 115 instead of 172.5. I hope someone can help me here. Thanks in advance.
Best Regards,
Suman.