Good day Kaushik.
Thank you for your reply.
Avg() doesn't seem to yield the correct results. my sales figures are down to the line level, so Avg() seems to give average per line and not average sales per site. my initial expression seems correct to sum up all sales and divide by 12 to get the average per month, just not sure how to get the correct average if a particular month or day is selected.
this is the expression that i am currently using.
thank you all so much.
i have added the Count(Distinct Monthfield) expression suggested by Ridhaa to get the average for the year. i have also added a if into the expression so that if there is only one month selected that it would then divide by 365 days to get the average per day.
hope this will be correct.