Issue with field selection upon Set analysis

[#1]

hi all,

I have the next set analysis expression:

Sum({$<OPCODE={'*'}-{'CANCEL''},MA={"*"}-{''}>} SUBSCRIBER_COUNT)

but the problem I have is that when I want to make a selection on MA it doesn't work.

the condition not to sum the ones with empty MA is very important for the total. but makes a certain selection on this field not work.

does anyone have an idea how to solve this?

thanks,

Boris

[salto]

Hi,

in the load script, try to assign a value (Empty) to the empty MA fields. Then:

Sum({$<OPCODE={'*'}-{'CANCEL''},MA={"*"}-{'Empty'}>} SUBSCRIBER_COUNT)

Hth.

[tresesco · Accepted solution]

Try with exclusion operator '-', like:

Sum({$<OPCODE={'*'}-{'CANCEL''},MA -={''}>} SUBSCRIBER_COUNT)

[#4]

Hey Boris..

It will work with the same expression ..  it is not recating on selections

Because u specified  *  in the expression , represents all values ,

If u observe eventhough u are try same expression in text box also not react..

one more thing is it may not the key field ...

Regards,

koti