1 2 Previous Next 15 Replies Latest reply on Nov 1, 2013 12:31 PM by Jonathan Drummey

    Is it possible to "filter" a value but instead of filtering it convert the value to NULL?

    Leticia Soroa

      Hi

       

      I would like to be able to filter some values but rather than exclude them from the table get NULL instead. So let's say I have the names of the clients and the country where they are from. If I exclude Spain I would like to get in the country column NULL rather than taking the value of the client off. Is this possible?

      I don't want to use parameters as you can only select one at the time.

       

      Thanks for your help!

       

      Leticia

        1 2 Previous Next