Expression Not working

[soniasweety]

Hi all,

I created the variables

LastWeek =Week(today())-1     result:35

his week=week(today())     result:36

but when I use the below expression sometime its working some time its not working?    what is the issue?

below separate expresions tried  both giving some time correct sometime wrong.

=Count({<Flag={'1'},WeekNumber={'=$(ThisWeek)'}>}distinct Id)

=count({$<Week={$(=LastWeek)}>}distinct Number)

=Count({$<Flag={'0'},WeekNumber={$(=LastWeek)}>}distinct No)

[soniasweety]

[sunny_talwar]

Don't know...

[soniasweety]

is exp wrong?   if I try  flag separate selection and variable all working

any other way to show variable with in set analysis?

[sam_grounds · Accepted solution]

Is this not to do with having two sets of '=' symbols? One in your expression and one in the variable.

Try setting This week to

     week(today())

and LastWeek to

     (Week(today())-1)

=Count(DISTINCT {$<Flag={1},WeekNumber={$(ThisWeek)}>} Id)

=Count(DISTINCT {$<Week={$(LastWeek)}>} Number)

=Count(DISTINCT {$<Flag={0},WeekNumber={$(LastWeek)}>} No)

[soniasweety]

thanks I will try and let you know

[soniasweety]

yes, its working fine thanks

[sam_grounds]

No problem, glad it helped!