Calculating Summary Cost Values ??

[Glenn]

I have a table setup as follows:

Task Name ------- Total Cost --- Amount Paid --- Balance Remaining
=========================================
Project Summary $170 $50 $120
Task A
Task 1a $100 $30 $70
Task 2a $50 $0 $50
Task B
Task 1b $20 $20 $0

Can anyone tell me how to set up these fields to calculate accrodingly?

Excel seems much more intuitive than Project. I have a lot of reference and
some coding background and yet the solution to this seemingly simple task
appears all too difficult via Project...

Thanks for any feedback or help on this

 

[Mike Glen]

Hi Glenn,

Welcome to this Microsoft Project newsgroup

If Amount Paid is in Cost4 field, then the formula is [Cost]-[Cost4]

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #14 - Customizing Fields, at this site:
http://tinyurl.com/2xbhc (Perhaps you'd care to rate the article before
leaving the site, Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

 

[John]

Glenn,
No need to cross post. Gerard provided a reply on the main Project
newsgroup.

John