This content has been marked as final. Show 6 replies
I currently have a table which contains a number of field and I have applied various filters to get the desired data. As I need to create some charts I need to change this to set analysis so I can summarise the data.
My current syntax is :
if(VacProgress='In Progress' and
(vacstate<>'Draft' and vacstate<>'In progress'and vacstate<>'Refused') and
not wildmatch(empjobref, '*VCP*'),
Can anyone help me change this expression so it works with set analysis?