Hi,
I would like to add a column "Charged Division" and "Charged Department" in one of my existing report. Problem is both field exists as a custom fields but value are different. Is there a way to perform a value lookup to other fields being used in the report?
Here is a list of fields I am using:
- Home Department: [Expense].[Employee Information].[Org Unit 2 - Code]
- Home Division: [Expense].[Employee Information].[Org Unit 1 - Name]
- Charged Department: [Expense].[Expense Allocation].[Custom 12 - Name]
- Set as "substring([Custom 12 - Name], 1, 3)" to match format of Home Department
- Charged Division: [Expense].[Expense Allocation].[Custom 11 - Name]
Given these fields, is there a possible expression to have a field that looks up the Charged Department to Home Department so Charged Division would display the values of Home Division? I've tried using the "search case" construct but resulted in error.
Many thanks,
P
