Combine a custom Yes/No field to an existing Exception Expression
Content
Hello,
Currently in several of our reports related to incident, we have an Exception that changes the type of a row in the report if the incident has been Escalated by business rules:
if((incidents.escllevel=6 | incidents.escllevel=2 | incidents.escllevel=3) & incidents.status_type <>2 & incidents.c$response_sent_2=0, 1, 0 & orgs.c$enterprise_org='No', 'Yes') -> equals 1
As we also have two group of SLA (Normal and Enterprise), we also have a seperate exception to mark out incidents with an Enterprise SLA based on a custom field:
orgs.c$enterprise_org equals 'Yes'
The orgs.c$enterprise_org is a Yes/No field.
Tagged:
0