Aum(Value) where Value in a field is selected

[alec1982]

Hi Guys,

how can I make the following:

Sum ({<[Client]= {GetFieldSelections[Client}>}[Item])

I konw this is not doable within Set Analysis but anybody knows how to do it?

Thxs,

Alec

[shree909]

Hi,

create a variable  getfieldselections(client) =vclient and use this variable in the  set analysis.

The issue u will have is either u need to select the client atleast once. or else it will thow an error.

if i am wrong can u post a sample file..

Thanks

[er_mohit · Accepted solution]

Try this

Sum({<[Client]={"$(=[Client])"}>}[Item])                    

Hope it helps

[alec1982]

Hi, I havent tried yet but as a feed back it should not throw an error as I have the list box to have one value selected always.

Thxs,

[Gysbert_Wassenaar]

Ehm... how about sum(Item)? Any selection you make in the field Client will automatically be applied to the expression unless you explicitly overrule it with a set modifier. So sum({<Client=p(Client)>}Item) and sum({<Client={'$(=only(Client))'}>}Item) are the same as sum(Item) if you only select one client.

[#6]

Obviously correct