Hi All,

I have a report that looks specifically for incidents which are currently out of SLA. The report then tally's these up and displays this in a crosstab.

Within the same report, I am also trying to query in a separate cross tab incidents which have not been updated within 14 days or longer. I created a separate formula to pull through these incidents. However once I put this in the cross tab, an additional field appears '0.00'. The cross tab is counting incidents which HAVE been updated as well as correctly identifying the incidents that don't. Is there a way I can supress the 0.00 field or something I can add into the formula to stop it being counted in the first place?

Formula:

if {inc_data.last_action_date} >= CurrentDate - 14 then {incident.incident_ref}

Any help would be greatly appreciated!

Thanks,
Chris

Thanks for the reply, I have tried this, however the problem is, it isn't showing as an empty row. If the incidents don't match the criteria and are false, the cross tab will assign the false records as 0.00 and perform a count on how many have equalled as false. It's trying to supress the false values within the cross tab if possible.

Thanks,
Chris