Results 1 to 2 of 2

Thread: RunningValue

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: RunningValue

    I am trying to use a runningvalue in reporting services, but I'm not sure if I'm doing this correctly. I'm trying to get a running total

    of the remainig hours that a student would be due for the month a week or year. =RunningValue(Fields!HoursRequired, sum "table_Group1"), but I'm not sure if I'm doing this correctly

    week 1
    [Hours required]
    40

    [category of hours]
    Cultural

    [Hours Earned]
    1

    [Hours Still due]
    39.00



    Week 2

    [Hours Required]
    79.00

    [Category of Hour]
    Cultural

    [Hours Earned]
    1


    [Hours still due]

    78.00

  2. #2
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    I think I got it

    =Fields!Required_hours.Value-RunningValue(Fields!Earned_hours.Value, sum, "DataSet1")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •