SSRS RunningValue start with a particular row

Hi Experts!

I need help figuring out how to configure the RunningValue function to start computing on a particular row.
It should always start accumulating on row 3. Here is my sample data:

ID        MyVal     Running Total            RowNumber
112     10                                           1
112      5                                            1
112      2          2                                1
202      3          5                                2
512      5          10                              3
125      1          11                              4
456      2          13                              5
 
The Row Number column is using the function ROW_NUMBER() -- just incase it's needed.

I tried different styles like:
=IIF(Fields!RowNum.Value = 1, "",RunningValue(Fields!MyVal.Value,SUM,NOTHING))

But it is still computing from the first row, it is just hidding those rows visually.

Thanks!
LVL 15
Faiga DiegelSr Database EngineerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mimran18Connect With a Mentor Commented:
Hi,
   It will give you the running total after row 3 not from 1st row.

=RunningValue(iif(Fields!RowNum.Value >3, CDbl(Fields!MyVal.Value), CDbl(0)), Sum, Nothing)

Cheers
0
 
lluddenCommented:
make a hidden column and then sum that column.

IIF(Fields!RowNum.Value = 1,0,Fields!RowNum.Value))
0
 
Alpesh PatelAssistant ConsultantCommented:
0
 
Faiga DiegelSr Database EngineerAuthor Commented:
This works! I just had to change the RowNum value (of the 3rd 1s), so the RowNum looks like:

1
1
2
2
3
4
5

Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.