New Views are not displaying Customized calculated fields value

[Michael Jansen]

I created a new view based on some native fields along with some custom
fields. None of the custom field values are calculating and showing up in the
view:

The custom fields do not seem to be complicated. here they are

Earned Work hours = INT([Work]/60)*([Physical % Complete]/100)
Productivity = IIf([Actual Work]=0,0,([Earned Work Hours]/([Actual
Work]/60))*100)
WorkHours Forecast = IIf([Actual
Work]=0,([Work]/60),([Work]/60)/([Productivity]/100))

The view is set at the Security Category of "My Projects"

Thanks,

 

[Prasanna Adavi, PMP, MCTS]

I am assuming that you have this problem in PWA View, not Project Pro view.

1. Do these fields work in Project Pro?

2. Asuming your formulae are working properly in Project Pro , did you restart project Publish the project after creating these Custom fields?





Michael Jansen wrote:

New Views are not displaying Customized calculated fields value
11-Feb-10

I created a new view based on some native fields along with some custo
fields. None of the custom field values are calculating and showing up in th
view

The custom fields do not seem to be complicated. here they ar

Earned Work hours = INT([Work]/60)*([Physical % Complete]/100
Productivity = IIf([Actual Work]=0,0,([Earned Work Hours]/([Actua
Work]/60))*100
WorkHours Forecast = IIf([Actua
Work]=0,([Work]/60),([Work]/60)/([Productivity]/100)

The view is set at the Security Category of "My Projects

Thanks,

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to display a Gravatar Image with 100 Percent Client Script Code
http://www.eggheadcafe.com/tutorial...c-b0877c10ecb4/how-to-display-a-gravatar.aspx

 

[Prasanna Adavi]

1. Are the fields working in MS project Pro?

2. If the fields are working in MS Project Pro, but not showing in PWA, try
publishing the project.

 

[Michael Jansen]

This worked but how do i format the fields to be "percent" or "one decimal"?

 

[Prasanna Adavi]

Off the top of my head, this is what I think should work. Make your Custom
Field a "text" field, and add the following to the end of your code. Make
sure your syntax is correct.

IIF (Condition, int(true)*100, int (false)*100) & "%"

--
Prasanna Adavi, PMP, MCTS

This worked but how do i format the fields to be "percent" or "one decimal"?

I am assuming that you have this problem in PWA View, not Project Pro view.

1. Do these fields work in Project Pro?

2. Asuming your formulae are working properly in Project Pro , did you restart project Publish the project after creating these Custom fields?





Michael Jansen wrote:

New Views are not displaying Customized calculated fields value
11-Feb-10

I created a new view based on some native fields along with some custom
fields. None of the custom field values are calculating and showing up in the
view:

The custom fields do not seem to be complicated. here they are

Earned Work hours = INT([Work]/60)*([Physical % Complete]/100)
Productivity = IIf([Actual Work]=0,0,([Earned Work Hours]/([Actual
Work]/60))*100)
WorkHours Forecast = IIf([Actual
Work]=0,([Work]/60),([Work]/60)/([Productivity]/100))

The view is set at the Security Category of "My Projects"

Thanks,

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to display a Gravatar Image with 100 Percent Client Script Code
http://www.eggheadcafe.com/tutorial...c-b0877c10ecb4/how-to-display-a-gravatar.aspx
.

 

[Michael Jansen]

There are so many fields with percenatage within Proj Server you woudl thing
you could format a number field?

Off the top of my head, this is what I think should work. Make your Custom
Field a "text" field, and add the following to the end of your code. Make
sure your syntax is correct.

IIF (Condition, int(true)*100, int (false)*100) & "%"

--
Prasanna Adavi, PMP, MCTS

This worked but how do i format the fields to be "percent" or "one decimal"?

I am assuming that you have this problem in PWA View, not Project Pro view.

1. Do these fields work in Project Pro?

2. Asuming your formulae are working properly in Project Pro , did you restart project Publish the project after creating these Custom fields?





Michael Jansen wrote:

New Views are not displaying Customized calculated fields value
11-Feb-10

I created a new view based on some native fields along with some custom
fields. None of the custom field values are calculating and showing up in the
view:

The custom fields do not seem to be complicated. here they are

Earned Work hours = INT([Work]/60)*([Physical % Complete]/100)
Productivity = IIf([Actual Work]=0,0,([Earned Work Hours]/([Actual
Work]/60))*100)
WorkHours Forecast = IIf([Actual
Work]=0,([Work]/60),([Work]/60)/([Productivity]/100))

The view is set at the Security Category of "My Projects"

Thanks,

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to display a Gravatar Image with 100 Percent Client Script Code
http://www.eggheadcafe.com/tutorial...c-b0877c10ecb4/how-to-display-a-gravatar.aspx
.

 

[Gary Chefetz]

Unfortunately, if you did format them, they wouldn't work very well in
formulas and the OLAP cube.

There are so many fields with percenatage within Proj Server you woudl
thing
you could format a number field?

Off the top of my head, this is what I think should work. Make your
Custom
Field a "text" field, and add the following to the end of your code. Make
sure your syntax is correct.

IIF (Condition, int(true)*100, int (false)*100) & "%"

--
Prasanna Adavi, PMP, MCTS

This worked but how do i format the fields to be "percent" or "one
decimal"?

:

I am assuming that you have this problem in PWA View, not Project Pro
view.

1. Do these fields work in Project Pro?

2. Asuming your formulae are working properly in Project Pro , did
you restart project Publish the project after creating these Custom
fields?





Michael Jansen wrote:

New Views are not displaying Customized calculated fields value
11-Feb-10

I created a new view based on some native fields along with some
custom
fields. None of the custom field values are calculating and showing
up in the
view:

The custom fields do not seem to be complicated. here they are

Earned Work hours = INT([Work]/60)*([Physical % Complete]/100)
Productivity = IIf([Actual Work]=0,0,([Earned Work Hours]/([Actual
Work]/60))*100)
WorkHours Forecast = IIf([Actual
Work]=0,([Work]/60),([Work]/60)/([Productivity]/100))

The view is set at the Security Category of "My Projects"

Thanks,

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to display a Gravatar Image with 100 Percent Client Script Code
http://www.eggheadcafe.com/tutorial...c-b0877c10ecb4/how-to-display-a-gravatar.aspx
.

 

[kahuna]

Maybe this is something as simple as not setting the width of the custom
field correctly in the view. Check it out.