2 Replies Latest reply: Aug 23, 2013 8:13 AM by Gysbert Wassenaar RSS

    Filtering rows with IF expression in which one value does not exist

      Hi!

       

      I'm trying to build and expression to find out all the people who do not finished any courses for which they get CourseCredits. In my data model the CourseCredits field is linked to many statuses (such as failed and planned) and so I need to filter out all the rows with the Status 'Done'.

       

      I tried the following expression but it just filters out the Status values 'Done' whereas I want to filter all the people who do not have Status 'Done':

       

      = sum(if(Status <> 'Done', CourseCredits, 0))

       

      Could somebody help me out what I should use here?

       

      All the best,

       

      Mikael