While I work with the version in 8.1 and 8.2, I assume the logic would remain the same: Create a calculated field with the following logic if <field> not contains "Generator" then return <value> else return missing Missing can be replaced with 0 if preferred. In 8.1 and 8.2, there is an option to preview your result. Wherein generator exists, the corresponding result would be missing/ 0. Values would only exist where the string in the condition does not exist. Use the calculated field in the gauge. The aggregates of missing/0 values would remain 0, hence giving you the total. Note: from what I see, you may also need to put an 'AND' clause to remove values pertaining to Total Power PLant ( to avoid duplication) Hope this is what you were looking for.
... View more