1 Reply Latest reply on Jul 23, 2018 2:49 PM by Shinichiro Murakami

    using parameter to create a filter

    nikhil.jog

      I have a column 'Name" that has names of people working on a project. This column could have 1 or more values as >1 person could work on a project. I would like to create a filter which could be used to show projects on which a particular person is working on. Due to constraint that >1 person could work on a project, i couldn't create a filter directly from the column as that filter could also show values like

      Person1

      Person1,Person2

      Person1, Person2, Person3

      etc

       

      to overcome the problem I created a parameter [team lead name parameter] that has names of different people and created a calculated field using a formulae CONTAINS([Name],[team lead name parameter] ) and then applied filter on that calculated field and selected TRUE in it. This way i can select different values for parameter and i get to see projects by Name

       

      My problem is that now, I cannot see all the projects when i am not interested in filtering data by Name. So i added value "All" to my parameter and I tried to modify my formulae of the calculated field to

      "

      IF ([team lead name parameter] = "All") THEN TRUE else CONTAINS([Name],[team lead name parameter] )

      END

       

      "

      but that throws an error 'cannot use Boolean type in if expression'. How could i modify the formulae?