topic Re: Manage null values in a Table in App Development

Manage null values in a Table

c_pannese — Fri, 20 Jul 2018 11:00:49 GMT

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 — Fri, 20 Jul 2018 11:15:22 GMT

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 — Fri, 20 Jul 2018 11:19:51 GMT

or this:

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

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

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

ogautier62 — Fri, 20 Jul 2018 11:20:09 GMT

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