How to calculate the avg weekly sales in a Textbox

[btrompetter]

Hello,

I want to show the average weekly sales in a textbox.

I think about a formular like this but it didn't work:

sum(
aggr(
{ $<
Year = {$(=year(today()))}
>
}
sum(Sales), Week) / count(STORE_NO)
) / max(total Week)

Do you have a hint for me?

regards

Bastian Trompetter

[#2 · Accepted solution]

I would put the set analysis (the whole {}-thing) into the second sum between "(" and "sales"...