Set Analysis

[bobbydave]

I am wondering what is wrong with this.

Service is made up of groups.

I am trying to break it down and don't want X and Y to be part of group and when eliminated, I then want the Service to show what I have left in the group.

=sum( {<
if(Group <> 'X', if(Group <> 'Y', Group)) >}

TV_Number

)

[MindaugasBacius · Accepted solution]

Try this:

Sum({<
    Group -={'X', 'Y'}
>}
TV_Number)

[pooja_sn]

sum({<Group -={ 'X', 'Y'}>}TV_Number)

[ankit777]

Hi

Try this

sum({<Group-={'X','Y'}>TV_Number}

[Kushal_Chawda]

try

=sum( {<Group-={'x','Y'} >} TV_Number)

its better to create the Flag In script.

if(not match(Group,'X','Y'),1,0) as FlagGroup

then write set analysis like below

=sum( {<FlagGroup={'1'} >} TV_Number)

[Kushal_Chawda]

[CELAMBARASAN]

You have to write anyone like below

=sum(

if(not Match(Group , 'X','Y'),

TV_Number)

)

Prefer to use below Set Analysis expression

=sum( {<Group-={'X', 'Y'}>}

TV_Number

)