I have imported a list of 1,914 employees into a dimension called “Ramp Users.”
In my Transaction List, I have two key properties:
-
Description – this contains text fields that include employee names (e.g., “Airfare reimbursement – John Doe”).
-
Ramp User – this is where I want to pull in the matching employee name from the Ramp Users dimension.
My goal is for the Ramp User property to automatically identify and display the employee name from the Ramp Users dimension if that name is found within the Description field of the Transaction List.
I tried using the following formula in the Ramp User property: IF(CONTAINS('Ramp User'.Name[BY:'PL GL Data'], 'PL GL Data'.Description), 'Ramp User'.'Ramp User Name')[REMOVE FIRSTNONBLANK:'Ramp User']
But I Received an error: “The formula reached 1 G cells during one of its execution steps, exceeding the maximum size allowed (1 G)”
Please help me resolve this.




