Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-27-2019, 03:14 PM
squeezebox squeezebox is offline milestone report Windows 10 milestone report Office 2016
Novice
milestone report
 
Join Date: Feb 2019
Posts: 1
squeezebox is on a distinguished road
Question milestone report

I don't use MS project 2016 much so please forgive me if this is a stupid / easy question to answer.

The standard reports don't give me what I'm looking for. I've tried creating my own report using filters and custom filters.



Please have a look at the screenshot, showing an example Gantt to the left and my desired report to the right.

It must be possible - but how?

Thanks for your help.
Attached Images
File Type: jpg milestone-report.JPG (78.9 KB, 15 views)
Reply With Quote
  #2  
Old 05-13-2021, 03:02 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline milestone report Windows 10 milestone report Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

Add 3 custom fields to your View, say Number 1, Number2 & Text1.

Rename Number1 to Milestone Total and enter the formula IIf([Milestone],1,0) and for summary rows calculations, tick Rollup and select Sum from the dropdown.


Rename Number2 to Completed Milestone and enter the formula IIf([Milestone] And [% Complete]=100,1,0) and for summary rows calculations, tick Rollup and select Sum from the dropdown.


Rename Text1 to Milestone % and enter the formula IIf( [Summary] AND [Milestone Total] > 0, Format( [Completed Milestone] / [Milestone Total], "Percent" ) , 0 ) and for summary rows calculations, tick Use Formula.


The Milestone % column will only calculate progress for tasks that are milestones as shown below.


=jerome
www.plannersplace.com
Reply With Quote
Reply

Tags
milestone, report

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Milestone Report in MS Project 2016 is Blank pru Project 1 06-16-2021 02:57 AM
Filename options when saving in Word 2013 - using report number at top of a report ? swayzak Word 1 09-08-2017 08:54 AM
milestone report Not all fields are exported to the Baseline Cost Report - Visual Report Rowena Project 3 05-30-2016 04:24 PM
Automation Process of Schedule Report Output and Report Check Score Card ! ozman86 Word VBA 1 11-19-2014 11:52 PM
milestone report milestone with more than 0 day duration ketanco Project 3 06-16-2014 11:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft