How do I write an expression utilizing the current week number?

[ljackson]

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.

[#2]

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?

[Gysbert_Wassenaar · Accepted solution]

week(today()) will return the week number of today. So perhaps sum(Sales)/week(today()) is what you're looking for.

[ljackson]

Thank you, that worked a treat!