ProjDateDiff Summary Explodes - Use Rollup Maximum

[Bruce McF]

When building a custom formula to find working days between two dates, trying
to use the Formula in the Summary calculation explodes. Using the rollup
Maximum works fine.

With this workaround, I am fine, but was wondering if I was doing something
wrong when trying to simply use the formula in the Summary/Group. I tried
putting the ProjDateDiff formula in Duration1 and Number1 and Project crashes
whenever I tried to use the formula for the summary of the custom field.

(Sorry, I was trying to get this in the main forum.)

 

[Jan De Messemaeker]

Hi,

Could it be that your input dates at summary level a not all dates but NA
f.i.?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Rod Gill]

And what version of Project and are you running the latest service pack for
it?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Bruce McF]

Jan,

Thanks for your response. One of my colleagues, an exceptional man, passed
away recently and I have been a bit distracted.

I see no NA's. All is well at the leaf level, but the exception
consistently occurs when I enable use of the formula at the summary level ...
whether the calculation is in a number or a duration.

The workaround seems to be working, but I am always anxious to know what I
am doing wrong. Since I have a workaround, please treat this a low priority
amongst your many inquiries. Again, even though this is part of a project
involving significant programming, there is no VB code involved in this ..
only custom calculations.

Thanks,
Bruce

 

[Bruce McF]

Rod,

Thanks. I don't know if you spotted my repy to Jans, but my apologies for a
late response. (I am very much enjoying your book by the way!)

Project 2007 (12.0.6211.1000) SP1 MSO (12.10.6213.1000)

As I mentioned to Jan, I do have a workaround .. just using an extra level
on indirection and another column ... so please treat this a lower priority.
I am just curious what I am doing wrong and how to learn from it.

Thanks,
Bruce