Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create an expression that calculates the average weekly sales of a product. I have the total of sales, but can't see how automatically include the current week number as a differential.
I have tried using the 'average' function, but this just averages the total number of entries - there will be more than one entry per week.
Can I use the current day to identify the current week, and then use that in the expression?
Thanks in advance for any help.
week(today()) will return the week number of today. So perhaps sum(Sales)/week(today()) is what you're looking for.
If you want to just calculate the weekly average of sales(not the evolution), you can do:
sum(Sales)/Week(Date(Today))
Is that what you are looking for?
week(today()) will return the week number of today. So perhaps sum(Sales)/week(today()) is what you're looking for.
Thank you, that worked a treat!