MS Project will not add data in Cost field
in [Project]
|
From: Django on 10 Feb 2010 21:26 Can anyone help me with the following problem? I have a column for cost, I enter the data, however, MS Project will not add the data and provide a total in the summary line. Appreciate any assistance in resolving this problem. -- Django
From: John on 10 Feb 2010 22:20 In article <DCBA6A63-573B-4D7A-B0EF-D1236DEA952E(a)microsoft.com>, Django <django32(a)hotmail.com> wrote: > Can anyone help me with the following problem? I have a column for cost, I > enter the data, however, MS Project will not add the data and provide a total > in the summary line. Appreciate any assistance in resolving this problem. Django, Since you are entering the data I assume you are using a spare cost field (e.g. Cost1). Project will only sum up data in spare fields if that field is customized with a formula, and then only if the user selects the option to sum up data for summary lines. Simply entering data will not create a formula. Off hand I can't think of any way to create a formula in the same field where you want to enter data. However you can do what you want using two spare cost fields. Enter your data in one field (e.g. Cost1). Customize another spare cost field (e.g. Cost2) with a formula that simply equals the value in Cost1. The formula and the option to sum up the data is set using Tools/Customize/Fields. Hope this helps. John Project MVP
From: Trevor Rabey on 11 Feb 2010 00:01 If you enter $ directly in the task Cost field, without assigning resources which themselves have costs, MSP assumes that you mean this to be a Fixed Cost, ie one which accrues to the task due to something other than resource assignments. You can see this most clearly if you have the Cost Table active, because it has the Fixed Cost field and the Cost field. Fixed Cost does not roll up, which leaves availiable the possibility of assigning Fixed Cost to Summaries. However, it is generally good practice to not assign any resources or costs (or Work) to Summaries. Also, it is good practice to not use Summaries for anything (other than as simple headings and sub-headings), including predecessor/successor links. (Note, this is especially a good idea because the "analyse time scaled data in excel" button on the Analysis toolbar does not "see" costs of Summaries, only of tasks, for the Cumulative Cost curve) -- Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING www.perfectproject.com.au "Django" <django32(a)hotmail.com> wrote in message news:DCBA6A63-573B-4D7A-B0EF-D1236DEA952E(a)microsoft.com... > Can anyone help me with the following problem? I have a column for cost, I > enter the data, however, MS Project will not add the data and provide a > total > in the summary line. Appreciate any assistance in resolving this problem. > > -- > Django
From: JulieS on 11 Feb 2010 05:31 On 2/10/2010 10:20 PM, John wrote: > In article<DCBA6A63-573B-4D7A-B0EF-D1236DEA952E(a)microsoft.com>, > Django<django32(a)hotmail.com> wrote: > >> Can anyone help me with the following problem? I have a column for cost, I >> enter the data, however, MS Project will not add the data and provide a total >> in the summary line. Appreciate any assistance in resolving this problem. > > Django, > Since you are entering the data I assume you are using a spare cost > field (e.g. Cost1). Project will only sum up data in spare fields if > that field is customized with a formula, and then only if the user > selects the option to sum up data for summary lines. Simply entering > data will not create a formula. > > Off hand I can't think of any way to create a formula in the same field > where you want to enter data. However you can do what you want using two > spare cost fields. Enter your data in one field (e.g. Cost1). Customize > another spare cost field (e.g. Cost2) with a formula that simply equals > the value in Cost1. The formula and the option to sum up the data is set > using Tools/Customize/Fields. > > Hope this helps. > > John > Project MVP Just a quick clarification. In Project 2007 at least, you can select a summary function (sum, min, max) for group or summary fields still allowing the user to enter data into the subtasks. See Tools > Customize > Fields. I hope this helps. Julie
From: John on 11 Feb 2010 11:26 In article <uh7TmVwqKHA.4604(a)TK2MSFTNGP05.phx.gbl>, JulieS <JulieS(a)discussions.microsoft.com> wrote: > On 2/10/2010 10:20 PM, John wrote: > > In article<DCBA6A63-573B-4D7A-B0EF-D1236DEA952E(a)microsoft.com>, > > Django<django32(a)hotmail.com> wrote: > > > >> Can anyone help me with the following problem? I have a column for cost, I > >> enter the data, however, MS Project will not add the data and provide a > >> total > >> in the summary line. Appreciate any assistance in resolving this problem. > > > > Django, > > Since you are entering the data I assume you are using a spare cost > > field (e.g. Cost1). Project will only sum up data in spare fields if > > that field is customized with a formula, and then only if the user > > selects the option to sum up data for summary lines. Simply entering > > data will not create a formula. > > > > Off hand I can't think of any way to create a formula in the same field > > where you want to enter data. However you can do what you want using two > > spare cost fields. Enter your data in one field (e.g. Cost1). Customize > > another spare cost field (e.g. Cost2) with a formula that simply equals > > the value in Cost1. The formula and the option to sum up the data is set > > using Tools/Customize/Fields. > > > > Hope this helps. > > > > John > > Project MVP > > Just a quick clarification. In Project 2007 at least, you can select a > summary function (sum, min, max) for group or summary fields still > allowing the user to enter data into the subtasks. See Tools > > Customize > Fields. > > I hope this helps. > Julie Julie, Thanks for the clarification. When I responded I didn't have Project open so I was going from memory. At least I "covered" myself by saying I couldn't think of a way :-) John
|
Next
|
Last
Pages: 1 2 Prev: MS Project 2003 File Size Growing Next: How to I create a Project with Start Date = Unknown |