Home Forums Reporting Services Reporting Services Is averaging textboxt value possible RE: Is averaging textboxt value possible

  • December 14, 2012 at 1:17 pm

    #1568824

    Do you mean you need to figure out the percentages?

    %Fail

    SUM(iif(Fields!Test.value="Fail", 1, 0)) / Count(Fields!Test.value)

    %Pass

    SUM(iif(Fields!Test.value="Pass", 1, 0)) / Count(Fields!Test.value)

    Fail/Pass

    iif(SUM(iif(Fields!Test.value="Pass", 1, 0)) <> 0, SUM(iif(Fields!Test.value="Fail", 1, 0)) / SUM(iif(Fields!Test.value="Pass", 1, 0)), 0)