Hi all,

When creating a column filter on a data table column, the option "Missing values" appears with an ON/OFF toggle button. What is this option supposed to do? I can't find any reference to it in any of the documentation. Even looking at the online animations, the toggle button does not appear. Could someone please throw me a bone on this one.

Thanks

That's simply a null filter. If product line is null do you want to see it.

On that report make one entry of product line null, for example:  

case
   when [C].[C_Great_outdoors_data_module].[page_3].[Product_line] not starts with 'M'
   then [C].[C_Great_outdoors_data_module].[page_3].[Product_line] 
end

and then run the report, you will see a null entry instead of Mountaineering Equipment. The use of toggle will be easy to see then.

Original Message:
Sent: Thu June 08, 2023 06:04 PM
From: Syd Shewchuk
Subject: Data Table Column Filter

Hi all,

When creating a column filter on a data table column, the option "Missing values" appears with an ON/OFF toggle button. What is this option supposed to do? I can't find any reference to it in any of the documentation. Even looking at the online animations, the toggle button does not appear. Could someone please throw me a bone on this one.

Thanks

------------------------------
Best regards,
Syd
------------------------------

Thanks Marc, my sanity is restored <â¿â>

Original Message:
Sent: Thu June 08, 2023 06:04 PM
From: Syd Shewchuk
Subject: Data Table Column Filter

Hi all,

When creating a column filter on a data table column, the option "Missing values" appears with an ON/OFF toggle button. What is this option supposed to do? I can't find any reference to it in any of the documentation. Even looking at the online animations, the toggle button does not appear. Could someone please throw me a bone on this one.

Thanks

------------------------------
Best regards,
Syd
------------------------------