netk week delivery only in Expression

[Anonymous]

Count({<[Delivery Week]={Week(Today)>} [Customer Name])... it throws error...pls coorrect it

[Anonymous]

hi

   i am  using Straight table... that  is always showing the current Delivery week Customer name...there is no current selectio or without current selection

[CELAMBARASAN]

Hi,

     Have you checked with this?

     Count({<[Delivery Week]={$(=Week(Today()))}>} [Customer Name])

     it will work fine.

What type of data you have in [Delivery Week] field?

Celambarasan

[Anonymous]

sorry ..... my Datas are like this

Delivery Week

week 8

week 7

week 45

week 51

week 9

[CELAMBARASAN · Accepted solution]

Hi,

     Then you should use like this

     Count({<[Delivery Week]={"$(='week ' & Week(Today()))"}>} [Customer Name])

Hope it helps

Celambarasan

[Anonymous]

$ is for current selection right.. then how it show correct data...without selection

[CELAMBARASAN]

Hi,

     Here $ is not for current selection its to evaluate this expression 'week ' & Week(Today()) before applying set analysis to the data model.

Celambarasan