How to only show current week (and year)

[Meg00]

I have a small problem

I have a textbox in wich I want to show number of calls this week, now it looks like this (Flagga_Kontakt, represent number of incoming calls):

=sum({<Week={$(#=week(today()))}>} Flagga_Kontakt)

The problem here is that it shows the sum of calls from both this week 2013 and same week the past years. Any suggestions?

[alexandros17]

you need a field "year"

=sum({<Week={$(#=week(today()))=}>} Flagga_Kontakt)

to add the condition in set analysis year={$(=year(today()))}

hope it helps

[#3]

=sum({$<Week={$(vThisWeek)}, Year={$(vThisYear)}>} Flagga_Kontakt)

Put into your variables :

LET vDateToday = num(Date(Today(), 'YYYY-MM-DD'))

or you could just say

Let vThisYear = num(Year(Today())

Let vDateToday = num(Today())

LET vThisWeektext = Week(vDateToday);

Remember if you use variaables with dates and not NUM infront, you need to put ' ' before your variables in your expression

[#4]

=sum({<Week={$(=week(today()))}>} Flagga_Kontakt)

or

sum({<year={$(=year(today()))}, Week={$(=week(today()))}>} Flagga_Kontakt)

[Meg00]

This shows the exact same numbers as before. It still shows totals of all years.

[#6 · Accepted solution]

try this

sum({<year={$(=year(today()))}, Week={$(=week(today()))}>} Flagga_Kontakt)

[Meg00]

Thank you, that worked just fine!