Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 )
or this:
=Concat(DISTINCT {<%Tp_dato={6}>} #um )
=Concat(DISTINCT {<%Tp_dato={5}>} #um )
=Concat(DISTINCT {<%Tp_dato={10}>} #um )
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