Is averaging textboxt value possible

• SSRSnewB

  SSC Veteran

  Points: 238

  More actions

  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

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  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)

• SSRSnewB

  SSC Veteran

  Points: 238

  More actions

  December 14, 2012 at 2:34 pm

  #1568839

  Yes, Thank you very much.