• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1098
  • Last Modified:

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!
0
Faiga Diegel
Asked:
Faiga Diegel
1 Solution
 
lluddenCommented:
make a hidden column and then sum that column.

IIF(Fields!RowNum.Value = 1,0,Fields!RowNum.Value))
0
 
mimran18Commented:
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
 
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now