Running Value /Count ?

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  April 29, 2015 at 8:18 am

  #317809

  Hi

  looking to keep count of a count value

  I have a textbox with exprtession =count(Fields!Prog.Value)

  which will have one of the 4 values 1,2,3, or 4

  on the footer or end of report I want to have a count of the number or 1,2,3, or 4's...

  something like

  COUNT of 1 Prog = 40

  COUNT of 2 Prog = 42

  COUNT of 3 Prog = 22

  COUNT of 4 Prog = 12

  Thanks

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  April 29, 2015 at 11:32 am

  #1794419

  Hi

  I did figure it out in case someone is looking for something similar..

  This works =runningvalue((IIF(count(Fields!Prog.Value)=1,1,Nothing)),sum,nothing)

  onto my next question 🙂

  Thanks