none
Formula for Custom field RRS feed

  • Question

  • I have EPM 2010 environment .

    I want to create formula based Custom field "A" in which i want data from windows user account field without domain name.

    In windows user account i have data like company\e222222 in new custom field i want only e222222

    How it is possible please suggest.


    kirtesh

    Wednesday, June 6, 2012 4:50 PM

All replies

  • kirtesh --
     
    I believe the following formula will work for you.  Copy and paste it into a custom Text field.
     
    Right([Windows User Account], (Len([Windows User Account])) - InStr([Windows User Account],"\"))
     
    Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, June 7, 2012 1:05 AM
    Moderator
  • Hi Dale,

    Thanks for your help. MPP and PWA both are accepting this formula.Formula is working for me when i open MPP and connect it to computer. I also wrote one formula that is working for me. But i have one issue here with both the formula's..

    When i open MPP 2010 and connect it to server,open resource sheet and add custom filed it is not giving me result that is EID value. It is giving me # Error for both the formula ( created by me and your formula).


    kirtesh

    Monday, June 11, 2012 10:53 AM
  • Kirtesh --
     
    Hmm.  Try this.  Open the Enterprise Resource Pool and check out some resources.  Apply the Resource Sheet view and insert the column containing the formula I provided for you.  Press the F9 function key to recalculate.  Does the formula calculate correctly now?  Let us know and we will try to help.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Monday, June 11, 2012 12:31 PM
    Moderator