|
|
|
date: Fri, 4 Jul 2008 21:47:00 -0700,
group: microsoft.public.project.developer
back
Re: ProjDateDiff Summary Explodes - Use Rollup Maximum
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
"Jan De Messemaeker" wrote:
> 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
> "Bruce McF" wrote in message
> news:969F2F12-B885-4424-B477-55AA15C6AF9E@microsoft.com...
> > 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.)
>
>
>
date: Sun, 20 Jul 2008 10:38:00 -0700
author: Bruce McF
Re: ProjDateDiff Summary Explodes - Use Rollup Maximum
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
"Rod Gill" wrote:
> 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
>
>
>
> "Jan De Messemaeker" wrote in message
> news:OB$LIXm3IHA.3544@TK2MSFTNGP06.phx.gbl...
> > 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
> > "Bruce McF" wrote in message
> > news:969F2F12-B885-4424-B477-55AA15C6AF9E@microsoft.com...
> >> 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.)
> >
> >
>
>
date: Sun, 20 Jul 2008 10:42:03 -0700
author: Bruce McF
|
|
