exclude some data with set analysis

[kamal_sanguri]

Hi All,

I am stuck in a situation where I need to exclude some data with set analysis.

Please check attached QVW for more information.

Thanks,

Kamal

[maxgro]

if(GetPossibleCount([service family])>1, sum(cost),

if([service family]='server',

  sum({$ <[Service category]=E({$ <[service family]={mainframe}>} [Service category])>} cost),

  sum(cost)

))

[kamal_sanguri]

Thanks for the help... I am sorry I could not clear the situation..

If both the items (Mainframe and server) are selected I need to have sum of all mainframe items and those items of server where service category is not alredy there in mainframe..

i.e  the sum of items which I see when I select mainframe and server items which I see when I select server.

Thanks,

[b_garside]

To exclude use a minus equals -= syntax;

Field-={"Value"}  Not equal

Field={"Value"}  must equal

Or  use E()  as post above suggested.

[maxgro]

if(GetPossibleCount([service family])>1,

  sum({$ <[Service category]=E({$ <[service family]={mainframe}>} [Service category])>+<[service family]={mainframe}>} cost),

  if([service family]='server',

  sum({$ <[Service category]=E({$ <[service family]={mainframe}>} [Service category])>} cost),

  sum(cost)

))