Set analysis sintax for date range

[jasmina_karcic]

Hi guys,

can you say me what is wrong in this sintax:

Sum({$<DATUM={">=$(=Date(weekstart(rangemin(today(), max(DATE)))))<=$(=Date(RANGEMIN(today(), MAX(DATE))))"}  >}VALUE)

For default, without choosing a date, it gives a good data in table. But if I choose one date, result give me just data for this picked date, not for interval weekstart(DATE)- DATE.

Thanks,

Jasmina

[sunny_talwar]

Do you have two fields? DATE and DATUM? If you do, do you make selection in DATE field? Try this

=Sum({$<DATUM = {">=$(=Date(WeekStart(RangeMin(Today(), Max(DATE)))))<=$(=Date(RangeMin(Today(), Max(DATE))))"}, DATE>} VALUE)

[jasmina_karcic]

No, all is one word (DATE)... I forgot to change DATUM into DATE, when I was changing...