Hi
can we get opportunity owner name in formula field .
case( Owner.Username ,"Ragul",'A', "Maran",'B',"Bhavani",'C',"Alia",'D',null).i got no error but in report came out 'null'.exactly my requirement is, need to assign A or B or C for each opportunity owner .
답변 2개
Hi,
These don't look like a valid usernames, usernames should be email format.
you are testing FirstName or LastName, so your formula is returning null. try this instead
case( Owner.FirstName ,"Ragul",'A', "Maran",'B',"Bhavani",'C',"Alia",'D',null)
