Would you try to use the CASE statement to calculate?
i.e CASE WHEN Number of Work Oder >0 THEN
SUM ( Number of Incidents + Number of Work Orders )
Number of Incidents
1 of 1 people found this helpful
It looks like my problem is bigger than that after doing some additional validation. The Number of Work Orders appears to be off as well. Have you ever tried to create a table like there where you have a summary of all work order and incidents by an assignee? I guess my join is off but it seems like it should work.
I don't have all modules installed otherwise would have created test report.