Skip to main content
tobyc49922805
Level 3
Dec 1, 2016 12:10 PM UTC
Solved

Report Builder - Running total

Hi,

I have scheduled report builder report which periodically (weekly) sends me data on selected activity. Alongside this, my client has now asked for a running total, so alongside the periodic (weekly) reporting they can also see the total performance since activity started.

 I'm wondering how best to do this in report builder. I basically want to anchor my start date, but have a rolling end date.

So, assuming the activity started on 01/01/2016 I want to set up a report which will show data from 01/01/2016 to date, without having to manually update the dates each week.

I've had a play with the customise date expression, but I can't seem to get it to work. In my head it would look something like this;

Start Date: 01/01/2016

End Date: cd-1

Has anyone come across this before?

 

Thanks

Toby

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
sebastianh26986
sebastianh26986Accepted solution
Level 2
Dec 1, 2016 4:29 PM UTC

Hi Toby,

there might be a nicer solution, but we just solved this by using "dates from cell" and just make to cells, one with your startdate and one with e.g. yesterday.

Best,

Sebastian

2 replies

sebastianh26986
sebastianh26986Accepted solution
Level 2
Dec 1, 2016 4:29 PM UTC

Hi Toby,

there might be a nicer solution, but we just solved this by using "dates from cell" and just make to cells, one with your startdate and one with e.g. yesterday.

Best,

Sebastian

Translate
tobyc49922805
Level 3
Dec 1, 2016 5:26 PM UTC

Thanks Sebastian,

I'll need to investigate how this will work with scheduled reports, but this could be a good solution. 

Thanks

Toby

Translate