Home > MSDN, SSRS > SSRS: Expression to find value for previous year SSRS

SSRS: Expression to find value for previous year SSRS

Its actually same question as done before for the link of my post

its new question raised in MSDN link here

user comments:-

I need some help with expressions.I need a report that shows calcul of a field for current year as well as previous year respecting this rule expression(Last-Last Previous)/Last Previous*100

Follow same steps as given in my previous post.

Just replace expression with below expression :-

=((last(Fields!value.Value) -Code.GetValueByKeyValue(Fields!keyvalue.Value)) /Code.GetValueByKeyValue(Fields!keyvalue.Value))*100

in column which is added outside of the group as shown in below screen:-

NewExpressionToGetDatasetResult

Run the report, report output look like below:-

Report2

So its working, For RDL code , add a comment with EmailID.

 

Thanks
Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Advertisements
Categories: MSDN, SSRS Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: