Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My current week expression is
week(Date) as week,
vWeek_1 = max(week)
vWeek_2 = max(week)-1
Sum({<weeks = {'$(vWeek_1 )'},Cal_Rep_FLAG ={1},>}Total_Call)
current week is working fine
my previous week is
Sum({<weeks = {'$(vWeek_2)'},Cal_Rep_FLAG ={1},week=>}Total_Call)
previous week is not working fine
if i click any week its working fine otherwise it show full values
help me sunny
thanks in advance
Hi,
maybe you have some spaces on your variables inside your Set analysis?
what is the difference between weeks and week fields ?
sorry typing mistake that is week only
Sum({<week= {'$(vWeek_2)'},Cal_Rep_FLAG ={1},week=>}Total_Call)
Using two time the field Week in set analysis like this, your expression will always take the Max(Week) regardless of the selected week
give me the full expression plz
remove the week exclusion from set
Sum({<week = {'$(vWeek_2)'},Cal_Rep_FLAG ={1}>}Total_Call)
Try one of these
Sum({<weeks = {"$(=vWeek_2)"}, Cal_Rep_FLAG = {1}>} Total_Call)
or
Sum({<weeks = {"$(=$(vWeek_2))"}, Cal_Rep_FLAG = {1}>} Total_Call)