2 Replies Latest reply on Jan 13, 2015 12:53 PM by tlman12

    Custom Reporting Count a value only if it equals a specific value

    tlman12 Rookie

      I'm trying to figure out how I can count a field only if it equals a specific value but I can't seem to find or figure out the syntax

       

      basically i want something like =Count(Fields!Severity.Value) where Fields!Severity.Value = "Critical"

       

      but that is obviously not right because it comes up blank.

       

      I've tried every language I know and the reporting seems to be a mix of SQL and vbscript but I just can't seem to get it.