Set Analysis, make set analysis selection equal to listbox

[#1]

Gents,

I like to make the selection of my sum command equal to the choosen week of a listbox.

Where Week  is the listbox field!

Therefore I made up the following set analysis command:

sum({<bdg.Week={$::Week}>} bdg.Budget_Marge)

somehow it doesn't work.... though no syntax error appears!

Who has got an idea???

Thx in advance!

F.

[#2]

Hii,

not sure about your field names,could you send a sample doc?

[#3]

I hope this code may help u..!!!

sum({<Week={'$(#Vweek)'}>} Data)

Vweek is a variable set as below

Vweek=concat(distinct Week, ';')

[deepakk · Accepted solution]

HI,

You can also try this code.

sum({<bdg.Week=P(Week)>} bdg.Budget_Marge)

Deepak

[#5]

Hi All,

thx for all  the suggestions!

@Deepak: works fine, thx!!

What is the "P" for a command, never saw it?

cheers

F.

[deepakk]

hi,

"P" means possible values. You can check the help file for set analysis. At botton they have explained about P and E

functions.

Deepak