Post reply

Is averaging textboxt value possible

  • December 14, 2012 at 12:43 pm

    #268110

    Test results - Textbox header column in Table region

    Pass - Textbox value

    Fail - Textbox value

    Fail - Textbox value

    Pass - Textbox value

    etc.

    etc.

    I have a textbox in the report header I want to add an expression something along the line

    Count(Fields!Test.value) = Fail/Count(Fields!Test.value)=Pass

  • 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)

  • December 14, 2012 at 2:34 pm

    #1568839

    Yes, Thank you very much.

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

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