Post reply

Previous Function

  • October 8, 2014 at 12:00 pm

    #297197

    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

    #1751148

    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

    #1752660

    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