Hi Rhonda, One of the gurus may be able to help, but I don’t expect it is possible to filter and then SUM the hours returned via a collection. One thing to note also is that if you use ‘hours’ in your listmethod field, it will return Hours that have been logged directly on the project, as opposed to on Tasks. I think you would be better off writing an Hours report, which filters using your time criteria, and group it by project name (with a Sum set on the Hours field). However, I’m keen to hear if there are any pieces of wisdom out there that make it possible to do what you were originally trying to do! Cheers. David Cornwell PMO Quality Assurance Analyst M: +61 422 453 599 E: david.cornwell@pentanasolutions.com [ http://www.pentanasolutions.com/media/images/Pentana-Solutions-Sig.jpg]
http://www.pentanasolutions.com/?utm_source=Emailsignature&utm_medium=Email&utm_campaign=Emailsignat... [social]
https://plus.google.com/b/102545672428646020884 [social] [social]<>[social]<>https://au.linkedin.com/company/pentana-solutions>[social]<>[social]<>http://www.pentanasolutions.com/?utm_source=ES&utm_medium=emailsig&utm_campaign=emailsiggeneral Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.
