Sum for the Current Week

[ksomosera10]

Hi,

I have this Expression:

=SUM([Local])

But the problem is that it sums all of my "Local" values for the whole year up to today. I have a column containing week number, so everytime I need to see the values of Local for the current week, I add a filter for weeks which makes the report not user-friendly. Can you help me out?

I want to automatically get the sum of Local but, just for the current week.

I have 3 columns that can be use.

Primary Index, Local(int), WeekNumber(int)

Is this possible?

Thanks!

[sumeet-vaidya · Accepted solution]

Hi Kevin,

Kindly use below Expression in your Set Analysis to get Local value for the Current Week.

Sum({<Weeknumber = {"$(=Week(Today()))"}>}Local)

Regards

Sumeet Vaidya