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]

What is the format of the data in the FW field, and what is the format of the variable $(vCurrentWeek) ?

Can you post the expression you are using to create vCurrentWeek?

[grajmca_sgp123]

its a number format (1,2,3,4.....)

this is the expression i have used =Week(Today())

[Colin-Albert]

So do you get data if you hard code a week number - use a number that exists in your FW data.

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

Can you add a list box on FW to see which values exist in your data?

[Anonymous]

If you are using

vCurrentWeek= Week(Today()) then vCurrentWeek always have the current week value .

You can not change it with the filter .

have you tried to see the value of vCurrentWeek in text box ??

Thanks

BKC

[jonathandienst]

You might need this:

sum({$<FW = {$(=vCurrentWeek)}>} Value)

[settu_periasamy]

if you are using =Week(Today()) in the expression, it gives the static result. Any week selection won't affect this.

may be you can try this also

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

[grajmca_sgp123]

yes I checked in text box it showing max week is 31 only but could not work the filter

[settu_periasamy]

Hi Rajesh,

Till this Weekend it will give '31' because of Week(Today()). And the selection won't affect.

[grajmca_sgp123]

ok then how do we make selections on weeks is there any solution