ApplyMap: which default_mapping value to use for integers

[BartVA]

Small "best practice" question. I am doing an ApplyMap which fetches integer values, including 0, positive and negative values. Which value do I put as "default_mapping" value?

I don't want it to be NULL.

I can't really use an integer.

Is it a bad idea to put '-' ? (As this is another data type than the rest of the values)?

[Antoine04]

Hello

Maybe just « not found » ?

then in your analyse you can also filter on « not found » and quickly see the values not found

Regards

[BartVA]

OK, so it's not a problem to mix strings with integers then?

[Antoine04]

Maybe yes if you plan to sum your DATA.

Other way would be to but them as 0 ?

[anat · Accepted solution]

you can't really use an integer ,so means  you are not going to use sum aggr function for this field.

so in that case you can use "NA" or "Not Found"