error in exp

[soniasweety]

Hi all,

currently my variable value is 

vCurrentWeekk=Week(today())

so in  expression I used    :  =Count({<WeekNumber={$(=vThisWeek)}>}id)     this will only only  this week data if I select other week in  filter it is not reflecting   so I tried below expression but its giving error

=if(GetSelectedCount()=0,week(today(),max(WeekNumber)))

[its_anandrjs]

Try this

=Count({<WeekNumber={ "$(=Max(WeekNumber))" }>}id)

=if( GetSelectedCount()=0,week(today() ),max(WeekNumber))) // In this you forget ")"

[Anil_Babu_Samineni]

May be missed parenthesis

=if(GetSelectedCount()=0,week(today()),max(WeekNumber))

[soniasweety]

still error in expression

[soniasweety]

still same error

[its_anandrjs]

Actually this is correct statement

=Count({<WeekNumber={ "$(=Max(WeekNumber))" }>}id)

Or

=IF( GetSelectedCount()=0, Week(Today()), Max(WeekNumber))

[soniasweety]

still the error in expression

[Anil_Babu_Samineni]

May be this? Try and check

=Count({<WeekNumber={'$(=Week(Today()))'}>}id)

[Kushal_Chawda · Accepted solution]

create variable on front end with below expression

=if(GetSelectedCount(Week)=0,week(today()),max(WeekNumber))

now try this expression

=Count({<WeekNumber={"$(=vThisWeek)"}>}id) 

or

=Count({<WeekNumber={"$(vThisWeek)"}>}id) 

Update: Error corrected in variable expression

[its_anandrjs]

Try this as well

=Count( {<WeekNumber={ "$(=Max(WeekNumber))" }>} id )

Or

=Count( {<WeekNumber={ '$(=Max(WeekNumber))' }>} id )

Or

=IF( GetSelectedCount()=0, Week(Today()), Max(WeekNumber))

Or

=IF( GetSelectedCount() = IsNull(), Week(Today()), Max(WeekNumber))