Hi, I am trying to use a couple of enterprise project cost fields. The first field simply to store the to revenue to be earned by the poject and the second to calculate the current average day rate taking into account all work in the project. The calculation used in the second is: [Enterprise Project Cost1]/([Work]/7.5) However when this field is calculated it seems to be a factor out. Can anyone assist me as to why the calculation does not give the correct answer that I work out when performing the calculation myself? For example my calculation would give the following answer: 65700/(1765.87/7.5) = 279.04 Yet project gives the following answer = 6.73. Thanks, David
Hi David, Try posting on the server newsgroup as this one is closing down. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address:http://project.mvps.org/faqs.htm . Mike Glen Project MVP David Bowen wrote: > Hi, > > I am trying to use a couple of enterprise project cost fields. The > first field simply to store the to revenue to be earned by the poject > and the second to calculate the current average day rate taking into > account all work in the project. The calculation used in the second > is: > [Enterprise Project Cost1]/([Work]/7.5) > > However when this field is calculated it seems to be a factor out. Can > anyone assist me as to why the calculation does not give the correct > answer that I work out when performing the calculation myself? For > example my calculation would give the following answer: > > 65700/(1765.87/7.5) = 279.04 > > Yet project gives the following answer = 6.73. > > Thanks, > > David