[Jeff Wolf Contributions: 0Level 1☆]

Below gives me the hours for jobs with a status of non-billable and are house accounts

CASE WHEN {job.status} IN ( ‘Not Billable’, ‘Closed – Not Billable’ , ‘Not Awarded’ , ‘Closed – Not Awarded’ ) AND {job.custentity_labor_classification} IS NULL AND( {job.entityid} LIKE ‘ANSP%’ or {job.entityid} LIKE ‘NSIM%’ or {job.entityid} LIKE ‘DALS%’ or {job.entityid} LIKE ‘SQ1A%’ ) THEN {durationdecimal} ELSE 0 END

Below gives me the hours for jobs with a status of non-billable and are NOT house accounts (it isn’t working. It gives me hours for all jobs that have a status of non-billable. What am I doing wrong?

CASE WHEN {job.status} IN ( ‘Not Billable’, ‘Closed – Not Billable’ , ‘Not Awarded’ , ‘Closed – Not Awarded’ ) AND {job.custentity_labor_classification} IS NULL AND( {job.entityid} NOT LIKE ‘ANSP%’ or {job.entityid} NOT LIKE ‘NSIM%’ or {job.entityid} NOT LIKE ‘DALS%’ or {job.entityid} NOT LIKE ‘SQ1A%’ ) THEN {durationdecimal} ELSE 0 END
This is a cached copy. Click here to see the original post.

[Author]

Posts