Hi Pigment team!
Is there a formula to look for the names dimension name in the Memo, and populate the EE dimension in the new property? Thanks in advance!!
Best answer by Nathan
View original
Userlevel 6
+11
- Employee
- 163 replies
-
8 September 2023
- Answer
Hi,
You can probably cut the string by FIND() the Month (Aug 23 here, but you’ll have to search for each month), then LEFT() from the result of the find, gives you the name.
Then you can use ITEM() to match the name vs the Employee dimension, which should give you your employee usable for summing values onto it.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.