Calculations in a report

Rob van Dijk

I'm trying to create a report where i only see records with End Date = this week.

(so not 'the coming 7 days' or something, only this week#)

I have column 'Week# that shows the week# of the field 'End Date' in my sheet

=ROUND((([End Date]1 - DATE(2015, 1, 1)) / 7) + 0.49, 0)

in my report I defined in the 'What' part:

[Week#] is equal to [=ROUND(((today() - DATE(2015, 1, 1)) / 7) + 0.49, 0)]

(so if today is week number 32, i only expected rows with an End Date in the current week)

no result

Find more posts tagged with

Formulas

Reports

Project Management

Comments

Richard Rymill SBP

Surely you can use the Date filter in the Report to either select dates relevant to whenever "today" is ie + or minus 7 days. Or if you are seeking a report that selects a specific date range then that is available too. It doesnt need to be very complex?

Hope that helps, not sure by seeking a week number you are helping things?

JohnHinkle

Here is how you can select a date range:

Screen Shot 2015-08-13 at 11.26.08 AM.png

John Sauber

Rob,

See my post here. Weeks to Start can easily be turned into Weeks to Complete. You can then filter and report against this numerical field till the cows come home!

I think you're specifically looking to filter where this column is less than 2 (this will allow you to include upcoming and overdue tasks as well).