How can I write a formula for a calculated field in runtime to bring up a the executive name of a certain department or subdepartment from user profiles (which is synched from AD)!
I have used calculated field, inserted a formula for <userprofilelookup(username, "manager")> to bring up the manager of a certain user and other values such as department from the managed properties. Now I need to use the department name brought up for that user to display the executive name .. all in runtime.
any thoughts?