why don't my week filter will not work

[grajmca_sgp123]

Hi ...why don't my week filter will not work here. I have made the selections on week filter but data will not change here.i am not understanding reason for this.

=num(sum({$< FW = {$(vCurrentWeek)}>}Value)/1000000,'$#,##.##M')

[Colin-Albert]

To make selections on weeks, just use the expression sum(Value) and have a list box on the Weeks field.

[settu_periasamy · Accepted solution]

you can try this.

if(GetselectedCount(WeekFieldName)>0,

     num(sum({$< FW = P(Week Field Name)>}Value)/1000000,'$#,##.##M'),

    num(sum({$< FW = {$(vCurrentWeek)}>}Value)/1000000,'$#,##.##M'))

This will give the Current Week value, if there is no selection in the Week List Box.