Click here to Skip to main content
15,916,835 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi
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 (I work with MDX Query and i work with SSRS 2008).

Also the report runs on a Year Parameter. Below is an example for the result
for example i selected the years 2010 2011 2012 i can select another years because i have the report runs on a Year Parameter

HTML
             year
Data        2010    2011   2012
hp          14      25     30
Dell        17      18     20


and the result i want
HTML
year
 Data        2010    2011   2012  2011/2012 
 hp          14      25     30       0.002 (Last -Last Previous)/(last Previous*100) =(30-25)/(25*100) 
 Dell        17      18     20       0.0040


thanks
Posted
Updated 15-Nov-19 4:48am

1 solution

DateAdd(DateInterval.Year,-1,Today())
 
Share this answer
 
Comments
CHill60 15-Nov-19 11:30am    
You do realise that this question was posted 4 years and 7 months ago? The poster has had no further interaction with the site since asking the question.
Richard Deeming 18-Nov-19 16:34pm    
This code doesn't answer the OP's question.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900