Week to Date Calculation using set analysis

[sudhir0538]

Hi all

As per my knowledge i wrote this statement but it's not working fine as I expected.

I want to find the sum of the value where the date is between starting and end of the weeks date.

=Sum({<dtmdate={>=WeekStart(Today()) <=WeekEnd(Today())}>}Value)

Please help to resolve or if you have any other solution for doing this please suggest.

Sudhir,

[Gysbert_Wassenaar · Accepted solution]

Try this:

=Sum({<dtmdate={">=$(=WeekStart(Today()))<=$(=WeekEnd(Today()))"}>}Value)

And make your dtmdate really contains date values and not text strings that only look like dates.

[sudhir0538]

Thanks a ton Gysbert.It's working.

[jagan]

Hi Sudhir,

Check this link for more expressions similar to this

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Hope this helps you.

Regards,

Jagan.

[sudhir0538]

Hi Jagan,

Very useful info. Thanks .

[#6]

Hi Gysbert,

I need help here, I am trying to achieve count for last week's based on weekstart and weekend and my week starting from Friday and week ending on Thursday.

As per the screenshot I would like to get the sales from Friday to Thursday.

Please look into it.