Urgent: Programatically get the value of Calculated Field

[mna]

Hi,
I want to get the calculate fields's value Programatically like Project
Budget or Project Schedule for a specific project. How can I do it? Any help
would be highly appreciated.

Regards,

 

[Rod Gill]

Do you mean Work or cost for a project? Try:

activeproject.ProjectSummaryTask.Work

 

[JackD]

Which field do you want?

 

[mna]

Thanks for your responses.
I wanted to get the values of the indicators being shown in the sample
database like Project Schedule and Project Budget. They contains formulas.
If it is not possible then please let it know as well.



Regards,
Nadeem

 

[Rod Gill]

Hi,

Project Schedule and Project Budget are titles your admin has given these
columns. They are not standard names. If the columns are in project itself,
then double-click the project title and tell us the name of the column. If
the columns are in Project Web Access, then ask your admin person.

 

[mna]

It is Project Custom Text field and it is a formula which have following
value.

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",([Cost]+1)/([Baseline
Cost]+1)>1.2,"Overbudget by 20% or more",([Cost]+1)/([Baseline
Cost]+1)>1,"Overbudget",True,"Under budget")

Now what I want to so how pass the name of the project and the name of the
above field and want to have values back like "OverBudget", "Under budget"
etc

Regards,

 

[Rod Gill]

So is this from VBA you want the answers?

If so, use:
Activecell.task.TextN

Where N is the text field number.


--

Rod Gill
Project MVP

It is Project Custom Text field and it is a formula which have following
value.

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",([Cost]+1)/([Baseline
Cost]+1)>1.2,"Overbudget by 20% or more",([Cost]+1)/([Baseline
Cost]+1)>1,"Overbudget",True,"Under budget")

Now what I want to so how pass the name of the project and the name of the
above field and want to have values back like "OverBudget", "Under budget"
etc

Regards,

Hi,

Project Schedule and Project Budget are titles your admin has given these
columns. They are not standard names. If the columns are in project itself,
then double-click the project title and tell us the name of the column.
If
the columns are in Project Web Access, then ask your admin person.

 

[mna]

Thanks Rod!
I want to access it from Project Server. If you can help that would be truly
appreciated.

thanks in advance

Regards,
Nadeem

So is this from VBA you want the answers?

If so, use:
Activecell.task.TextN

Where N is the text field number.


--

Rod Gill
Project MVP

It is Project Custom Text field and it is a formula which have following
value.

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",([Cost]+1)/([Baseline
Cost]+1)>1.2,"Overbudget by 20% or more",([Cost]+1)/([Baseline
Cost]+1)>1,"Overbudget",True,"Under budget")

Now what I want to so how pass the name of the project and the name of the
above field and want to have values back like "OverBudget", "Under budget"
etc

Regards,

Hi,

Project Schedule and Project Budget are titles your admin has given these
columns. They are not standard names. If the columns are in project itself,
then double-click the project title and tell us the name of the column.
If
the columns are in Project Web Access, then ask your admin person.

--

Rod Gill
Project MVP


Thanks for your responses.
I wanted to get the values of the indicators being shown in the sample
database like Project Schedule and Project Budget. They contains formulas.
If it is not possible then please let it know as well.



Regards,
Nadeem
Hi,
I want to get the calculate fields's value Programatically like
Project
Budget or Project Schedule for a specific project. How can I do it?
Any
help
would be highly appreciated.

Regards,

 

[mna]

So Should I assume there is no answer to this? Somebody please answer.

Regards,

Thanks Rod!
I want to access it from Project Server. If you can help that would be truly
appreciated.

thanks in advance

Regards,
Nadeem

So is this from VBA you want the answers?

If so, use:
Activecell.task.TextN

Where N is the text field number.


--

Rod Gill
Project MVP

It is Project Custom Text field and it is a formula which have following
value.

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",([Cost]+1)/([Baseline
Cost]+1)>1.2,"Overbudget by 20% or more",([Cost]+1)/([Baseline
Cost]+1)>1,"Overbudget",True,"Under budget")

Now what I want to so how pass the name of the project and the name of the
above field and want to have values back like "OverBudget", "Under budget"
etc

Regards,
"Rod Gill" <rod AT project-systems DOT co DOT nz> wrote in message
Hi,

Project Schedule and Project Budget are titles your admin has given these
columns. They are not standard names. If the columns are in project
itself,
then double-click the project title and tell us the name of the column.
If
the columns are in Project Web Access, then ask your admin person.

--

Rod Gill
Project MVP


Thanks for your responses.
I wanted to get the values of the indicators being shown in the sample
database like Project Schedule and Project Budget. They contains
formulas.
If it is not possible then please let it know as well.



Regards,
Nadeem
Hi,
I want to get the calculate fields's value Programatically like
Project
Budget or Project Schedule for a specific project. How can I do it?
Any
help
would be highly appreciated.

Regards,

 

[JackD]

As far as I know, the Project Server database stores the last value of the
customized field ("last" meaning the value that was calculated the last time
the project was opened, calculated and saved using Project Pro). To read it
you can simply find the value in the database.

I'm not a project server expert, but I'm pretty sure if you read the
pjsrvr.htm document that comes with Project Server it should tell you where
the fields are stored. From there you just need a SELECT statement and a
join or two.

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

So Should I assume there is no answer to this? Somebody please answer.

Regards,

Thanks Rod!
I want to access it from Project Server. If you can help that would be truly
appreciated.

thanks in advance

Regards,
Nadeem

So is this from VBA you want the answers?

If so, use:
Activecell.task.TextN

Where N is the text field number.


--

Rod Gill
Project MVP


It is Project Custom Text field and it is a formula which have following
value.

Switch(Len(CStr([Baseline Finish]))<3,"No baseline",([Cost]+1)/([Baseline
Cost]+1)>1.2,"Overbudget by 20% or more",([Cost]+1)/([Baseline
Cost]+1)>1,"Overbudget",True,"Under budget")

Now what I want to so how pass the name of the project and the name

of
the

above field and want to have values back like "OverBudget", "Under budget"
etc

Regards,
"Rod Gill" <rod AT project-systems DOT co DOT nz> wrote in message
Hi,

Project Schedule and Project Budget are titles your admin has given these
columns. They are not standard names. If the columns are in project
itself,
then double-click the project title and tell us the name of the column.
If
the columns are in Project Web Access, then ask your admin person.

--

Rod Gill
Project MVP


Thanks for your responses.
I wanted to get the values of the indicators being shown in the sample
database like Project Schedule and Project Budget. They contains
formulas.
If it is not possible then please let it know as well.



Regards,
Nadeem
Hi,
I want to get the calculate fields's value Programatically like
Project
Budget or Project Schedule for a specific project. How can I do it?
Any
help
would be highly appreciated.

Regards,