9 Replies Latest reply on May 15, 2017 1:04 PM by Fan Gong

    How to select a column where is not null in calculated fields

    Fan Gong

      Hi Guys,

       

      My data looks like below.

       

      IDColumnAColumnBColumnCColumnDColumnE
      1YESYESYESYES
      2NOYESYESYESYES
      3NOYES
      4YESYESNONO
      5YES
      6YESYESNOYES
      7NONO
      8YESYESYES
      9NOYES
      10YESYESYESYESNO

      I know how to create a dynamic selection by creating parameter and calculated field, but how to select, choosing one from columnA to columnE (if it's "all", do nothing) where the value is not null? For example, If select ColumnA, then not null value will be selected (ID1, 2, 4, 6, 8, 10).

       

      Thank you!

      Fan