Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
first of all, happy new year 2023 to all.
Attached is a screenshot of a table.
I would like to filter the ORDER column according to the "ZOFSUIVI_250" field. the orders should be displayed ONLY if ZOFSUIVI_250 is empty. I tried with a set analysis but I can't find the right syntax to filter according to an empty field. Can you help me? Thank you
Thank you for your help.
Hi @Jérôme5625
If the Z0FSUM_R.280 column is a dimension on your table, please use this formula:
=if(isnull([Z0FSUM_R.280]),'',Null())
And uncheck 'Include null values'.
[],
Pedro