Using an if-statement

[shahamel]

Dear users,

I have a small problem. I want to see all students who are not registerd at a specific school. So i use this script in a graph. This graph should show all students who are currently taking class at a specific school. The formule works. The only problem i have is that it only works when I select "Volgt opleiding" in the selectioon box which tells me wether a student is or isn't registerd at that school. I would like to have a working formula without having to make a selection in the selection box

if (StatusInschrijving='Volgt opleiding',COUNT(Distinct LeerlingID))

Gr. Sandeep

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Try the formula using set analysis

Count({< StatusInschrijving = {'Volgt opleiding'} >} DISTINCT LeerlingID)

Hope that helps.

Miguel

[shahamel]

Thanx