Hey John,
A real quick fix is it have an additional field named [Inactive Total]. You could then setup either a form rule or pipeline that says: When [Inactive] is true, change [Total] to 0 and change [Inactive Total] to the value that [Total] was/ is (this part will take some experimentation to see if you can accomplish both at the same time on a form rule, or if you have to do it in steps via pipelines.
This would then allow you to see the record on the report whilst the total doesn't record any additional values since the [total] field is now zero
------------------------------
Shane Miller
------------------------------