Adress empty fields in set analysis

[#1]

Hi all,

I have the attached table.

Now I have a text object with the next set analysis expression:

sum({<OPCODE_COUNT.OPCODE={'CANDIDATE'},OPCODE_COUNT.MA={''}>} SUBSCRIBER_COUNT)

I keep getting 0.

though the result should be 1 because I'm referring only to the last 3 rows in the table from a previous selection.

Any Idea how to address this empty fields?

[ali_hijazi]

these are null values not empty strings

you can the following to be able to refer to these null values

in your script add the following:

NULLASVALUE your_field;

SET NULLVALUE = 'OTHER';

...

YOUR LOAD SCRIPT GOES HERE

then you can refer to these in set analysis OPCODE_COUNT.MA={'OTHER'}

[#3 · Accepted solution]

Thanks, in the end I used the isnull() in the load script and gave it a value.