October 8, 2014 at 12:00 pm
I have a bar chart on my report and would like to show the change difference between the current and previous record, preferably as a percentage. I tried using the previous function in a report title, table, and text box on the chart, but no luck. Any one have any ideas? I have attached a jpg of the chart I am trying to mimic. Any help will be appreciated.
Thanks
October 8, 2014 at 10:30 pm
In my case, I just used an existing Enroll counts report...
=(Fields!NewEnrolls.Value-Previous(Fields!NewEnrolls.Value))/Fields!NewEnrolls.Value
The fun thing about something like this is that if the NewEnrolls.Value = 0 then you get +/- Infinity... so you may need to do something in that case.
October 15, 2014 at 12:52 pm
Thank you very much for the reply. I ended up creating a new datasource, using a CTE to get the percentage change difference, and then adding the fields to a new chart title. I appreciate the feedback.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply