Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try this
sum({<year={$(=year(today()))}, Week={$(=week(today()))}>} Flagga_Kontakt)
you need a field "year"
=sum({<Week={$(#=week(today()))=}>} Flagga_Kontakt)
to add the condition in set analysis year={$(=year(today()))}
hope it helps
=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
=sum({<Week={$(=week(today()))}>} Flagga_Kontakt)
or
sum({<year={$(=year(today()))}, Week={$(=week(today()))}>} Flagga_Kontakt)
This shows the exact same numbers as before. It still shows totals of all years.
try this
sum({<year={$(=year(today()))}, Week={$(=week(today()))}>} Flagga_Kontakt)
Thank you, that worked just fine!