to get missing values in a field within the current selection

[Anonymous]

Hi,

Is it possible to get missing values in a field within the current selection via the function Concat?

Thank you in advance,

Larisa

[jonathandienst]

I am not sure what you mean. But if you mean can you select null and missing values, the answer is no.

But you can convert null values to a selectable value by using NULLASVALUE fieldname;

There is no way to select genuine missing values. What exactly would you select?

[Anonymous]

For instance all months are selected by default. If a user selects Brand A, then Months Jan and Feb are not active because Brand A has no ads in Feb and Apr.

I want to display a short text info for the end user saying that Brand A has no ads in Feb and Apr. Can I get text values Feb and Apr using a concat funcion?

[maxgro · Accepted solution]

maybe

=concat({1 <Months=E(Months)>} DISTINCT Months, ', ')

[Anonymous]

Thank you!