Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try with exclusion operator '-', like:
Sum({$<OPCODE={'*'}-{'CANCEL''},MA -={''}>} SUBSCRIBER_COUNT)
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.
Try with exclusion operator '-', like:
Sum({$<OPCODE={'*'}-{'CANCEL''},MA -={''}>} SUBSCRIBER_COUNT)
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