Manage null values in a Table

[c_pannese]

Hi All.

I'm starting from here:

Now I have to insert the description for each measure and i'd ike to create 3 new columns.

I'm trying to do that using if condition but the result is:

How can i create my new column filling the same row instead of generating 3?

What is the correct statement in this case?

Excluding null value clicking on the specific flag box , the result is an empty tabale.

Thank's a lot.

[petter]

I think this might work for you as as expressions:

=Only( {<%Tp_dato={6}>} #um )

=Only( {<%Tp_dato={5}>} #um )

=Only( {<%Tp_dato={10}>} #um )

[petter]

or this:

=Concat(DISTINCT  {<%Tp_dato={6}>} #um )

=Concat(DISTINCT {<%Tp_dato={5}>} #um )

=Concat(DISTINCT {<%Tp_dato={10}>} #um )

[ogautier62]

Hi,

what is #um ?

there's no agregate operator, just if that'w why null for other rows

add maxString before if,

or maybe only if there is only one #um

regards