Post reply

How to Count Values > 0 in a Tablix Row

  • September 28, 2012 at 9:15 am

    #393276

    I have a tablix report that aggregates data by month and displays an average / day as a summary column. I need to also add a Days with Count > 0 summary column. This is where i'm struggling with the expression language.

    How do I perform a COUNTIF in a tablix expression?

    Attached is a capture of the data I am working with.

    Greg Roberts

  • September 28, 2012 at 9:34 am

    #1543497

    I found an answer to my question here.

    Is there anything like "countif"?

    Here's the expression.

    =SUM( IIF( Fields!MyField.Value = 0,0,1))

    Greg Roberts

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply