Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this.
= if(Status <> 'Done', Sum(CourseCredits), 0)
also in Total Mode
check "Sum og Rows"
Thanks.
This filters out all the PersonID's that do not have a status Done, leaving only those persons that finished at least one course:
sum({<PersonID=p({<Status={'Done'}>}PersonID)>} CourseCredits)
This filters out all the PersonID's that do have a status Done, leaving only those persons that did not finish any course:
sum({<PersonID=e({<Status={'Done'}>}PersonID)>} CourseCredits)
Replace PersonID with the field that identifies your persons.