Week X of Datefield

[reporting_neu]

Hello everybody,

I need the sum of something from a given week. Unfortunately I can't do the calculation.

SUM({< WEEK(datefield) = {19}>}value)

How can I get the sum of week 19 for example?
Or even better, how do I get the next week's value dynamically?

Like:

SUM({< WEEK(datefield) = {Week(today)+1}>}value)

Can you help me please?

[tresesco]

Create a week field in the script, and try like:

SUM({< WEEKField = {'$(=Week(today())+1)'}>}value)

Or, with date field try like:

SUM({< datefield = {"=Week(datefield)=Week(today())+1"}>}value)