locked
help required on Resource Custom formula fields RRS feed

  • Question

  • I am facing 2 problems in project server 2010 PWA.

    1. I created a Formula custom field for the Resource Entity type but this formula field doesnt appear as a custom field parameter while editing or creating a Resource.

    2. I cannot use this formula custom field for creating another formula custom field in PWA server settings. I can query this custon field using backend DB but I cannot find this field in any of the front end PWA Views.

    Could comebody help me with these issues? I think that both r reffering to a common problem. Help required please.

     

    Tuesday, January 18, 2011 7:19 AM

Answers

  • mate, here is your answer: resource level custom formula field does not appear in views.

    i have found the similar thread for you, where Andrew had presented an alternative and also the reason for such design behavior.

    http://social.technet.microsoft.com/Forums/en-US/projectserver2010general/thread/2a8b2007-251a-45d0-994a-fbb0853a8a01

     

    You have to go for either one of the options in this thread. you can chose to go for the PSI if you are familiar with the PSI coding OR write a macro (which personally i think would be an easier job)

     

    Hope this helps.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, January 18, 2011 11:30 AM

All replies

  • Have you associated your Resource custom field with any of the Department? Because if this is the case then it will only be available for the resources associated with the same department as of the custom field. You need to leave the department field blank to be available for every resource.

    If not, then Let us know, and we can further investigate.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, January 18, 2011 8:05 AM
  • thanks for the reply, but i have not associated the field with any of the departments. still facing the issue.

     

    could you please dig down? thanks.

    Tuesday, January 18, 2011 9:26 AM
  • alrite, tell me have you set the behavior of the custom field = work flow controlled?
    if yes, then delete the custom field and create again if you want to set the value manually. the work-flow controlled fields cannot be set manually, it will only be controlled by the work-flow.

    Let me know if it helps?


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, January 18, 2011 10:07 AM
  • well no...i havent set the field to be workflow enabled.

    The field is actually a formula custom field (as i said earlier) but there are other non-formula custom fields that were created by me and are shown both on the resource data entry form and resource center view; plus they are also seen in the 'Pick Field' list, while i try to create new custom fields. The issue is only with the Formula custom field.

    Tuesday, January 18, 2011 10:50 AM
  • was the formula validated sucessfully when you created the enterprise custom field?

    there must be something wrong with the formula then, could you share with us the formula you are using.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, January 18, 2011 10:59 AM
  • there was no error when i saved it; but when i query the field using SQL server management studio it  shows NULL, means value is not calculated at back-end.

    the formula is:

    Year(Now()) - Year([Date of Joining])

    and by doing this i'm trying to display the number of years of an employee with the company.

    Tuesday, January 18, 2011 11:11 AM
  • mate, here is your answer: resource level custom formula field does not appear in views.

    i have found the similar thread for you, where Andrew had presented an alternative and also the reason for such design behavior.

    http://social.technet.microsoft.com/Forums/en-US/projectserver2010general/thread/2a8b2007-251a-45d0-994a-fbb0853a8a01

     

    You have to go for either one of the options in this thread. you can chose to go for the PSI if you are familiar with the PSI coding OR write a macro (which personally i think would be an easier job)

     

    Hope this helps.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, January 18, 2011 11:30 AM
  • Thanks! well i'll definately have to go the non-coding way. Do u have any idea how macros would be written in project server?
    Tuesday, January 18, 2011 11:42 AM
  • you have to write the macro in project professional, you cant write in PWA.and its the same as excel macro. write the macro in project professional, and save it in the enterprise project template so that it will available for every user.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, January 18, 2011 11:55 AM