Formulas involving summary task dates

[scott_hanebutt]

I am wanting to perform calculations bassed upon a summary's finish date.
When I refer to it though it seems to equal NA, as if it was calculated from
it's childeren on the fly. Is that the case? And if so is there a simple
way for me to calculate what the summary's finish date would be based on it's
children?

Any example code would be greatly appreciated.

Thanks,
Scott Hanebutt

 

[Brian K - Project MVP]

I am wanting to perform calculations bassed upon a summary's finish date.
When I refer to it though it seems to equal NA, as if it was calculated
from
it's childeren on the fly. Is that the case? And if so is there a simple
way for me to calculate what the summary's finish date would be based on
it's
children?

Any example code would be greatly appreciated.

Thanks,
Scott Hanebutt

It is an odd issue with how formulas work but you can do this by having a
Task Date field hold the Summary task finish date. use this formula:
IIf([Summary]=-1,[Finish],ProjDateValue("NA"))

 

[scott_hanebutt]

I tried your formula but all it returned was "NA". Can you check to see if
you made a mistake? Also can you tell me exaclty how the formula works?

Thanks,
Scott Hanebutt

I am wanting to perform calculations bassed upon a summary's finish date.
When I refer to it though it seems to equal NA, as if it was calculated
from
it's childeren on the fly. Is that the case? And if so is there a simple
way for me to calculate what the summary's finish date would be based on
it's
children?

Any example code would be greatly appreciated.

Thanks,
Scott Hanebutt

It is an odd issue with how formulas work but you can do this by having a
Task Date field hold the Summary task finish date. use this formula:
IIf([Summary]=-1,[Finish],ProjDateValue("NA"))

 

[Brian K - Project MVP]

IIf([Summary]=-1,[Finish],ProjDateValue("NA"))

Youhave to set the rollup settings for the field to "use formula". these
are just below the formula button on the customize field dialog.

 

[scott_hanebutt]

Thanks, it works great. However I also need the non-summary tasks finish
dates to be in the same column.

Scott Hanebutt

IIf([Summary]=-1,[Finish],ProjDateValue("NA"))

Youhave to set the rollup settings for the field to "use formula". these
are just below the formula button on the customize field dialog.

 

[Brian K - Project MVP]

Thanks, it works great. However I also need the non-summary tasks finish
dates to be in the same column.

Scott Hanebutt

IIf([Summary]=-1,[Finish],ProjDateValue("NA"))

Youhave to set the rollup settings for the field to "use formula". these
are just below the formula button on the customize field dialog.

Well that is not what you asked! Just have the formula be: [Finish].

 

[scott_hanebutt]

I originaly tried setting it equal to finish but then all the summary tasks
are "NA", hence the reason for my original question.

I need both the summary and the non-summary tasks finish dates in the same
column.

Thanks,
Scott Hanebutt

Thanks, it works great. However I also need the non-summary tasks finish
dates to be in the same column.

Scott Hanebutt

Brian K - Project MVP wrote:

IIf([Summary]=-1,[Finish],ProjDateValue("NA"))

Youhave to set the rollup settings for the field to "use formula". these
are just below the formula button on the customize field dialog.

Well that is not what you asked! Just have the formula be: [Finish].

 

[Brian K - Project MVP]

I originaly tried setting it equal to finish but then all the summary tasks
are "NA", hence the reason for my original question.

I need both the summary and the non-summary tasks finish dates in the same
column.

Thanks,
Scott Hanebutt

Thanks, it works great. However I also need the non-summary tasks finish
dates to be in the same column.

Scott Hanebutt

:

Brian K - Project MVP wrote:

IIf([Summary]=-1,[Finish],ProjDateValue("NA"))

Youhave to set the rollup settings for the field to "use formula". these
are just below the formula button on the customize field dialog.

Well that is not what you asked! Just have the formula be: [Finish].

Ah. It may well have been because of the "use formula" option NOT being
selected.

 

[scott_hanebutt]

That was the problem. It works exaclty the way I want it to now.

Thanks a lot for your time and patience.
Scott Hanebutt

I originaly tried setting it equal to finish but then all the summary tasks
are "NA", hence the reason for my original question.

I need both the summary and the non-summary tasks finish dates in the same
column.

Thanks,
Scott Hanebutt

scott_hanebutt wrote:

Thanks, it works great. However I also need the non-summary tasks finish
dates to be in the same column.

Scott Hanebutt

:

Brian K - Project MVP wrote:

IIf([Summary]=-1,[Finish],ProjDateValue("NA"))

Youhave to set the rollup settings for the field to "use formula". these
are just below the formula button on the customize field dialog.

--
Brian K - Project MVP
http://www.projectified.com


Well that is not what you asked! Just have the formula be: [Finish].

Ah. It may well have been because of the "use formula" option NOT being
selected.

 

[Brian K - Project MVP]

That was the problem. It works exaclty the way I want it to now.

Thanks a lot for your time and patience.
Scott Hanebutt

No problem at all. that is what we are here for.