Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2015, 12:27 PM
cool28uo cool28uo is offline Materials/Work Costs Per task Windows 7 64bit Materials/Work Costs Per task Office 2013
Novice
Materials/Work Costs Per task
 
Join Date: Jan 2015
Posts: 1
cool28uo is on a distinguished road
Default Materials/Work Costs Per task

Hello,

How can i see the costs per task seperated into materials costs and work costs?



Tnx
Reply With Quote
  #2  
Old 02-01-2015, 03:59 PM
JulieS JulieS is offline Materials/Work Costs Per task Windows 7 64bit Materials/Work Costs Per task Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

In the Task Usage view, add the Cost field.
Add the Text1 field and create a formula: [id] & " " & [Name]
Create a custom group with the following definition:
Group by:
Field: Text1
Field Type: Task
Order: Ascending
Then By:
Field: Resource Type
Field Type: Assignment (you'll need to check off the option "Group assignments not tasks"
Order: Ascending

Apply the group. Does it get you what you need?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Materials/Work Costs Per task Variable work task patrickd123 Project 1 10-09-2014 05:19 AM
Tracking materials over time Guloluseus Project 3 04-02-2013 11:08 AM
Materials/Work Costs Per task Costs are not adding to the summary task in cost1 column ketanco Project 1 06-14-2012 03:23 PM
Materials/Work Costs Per task overtime work effecting task duration user0044 Project 11 03-06-2012 07:20 AM
Work as percent of another task JohnG10 Project 0 12-10-2010 07:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:05 AM.


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