laudrupin9
New Member
- Joined
- Nov 8, 2016
- Messages
- 4
Hello
I hope you can help me:
Here my fonction used in the power pivot table:
=MID([DisplayName];FIND(CHAR(40);[DisplayName])+1;FIND(CHAR(41);[DisplayName])-FIND(CHAR(40);[DisplayName])-1)
Display Name
AAPP(Pedro)
AAPP(David)
AAPP(Juan Pablo).
AAPP(Maria Jose Pardo)
The target of my formula is to get this result:
Display Name
Pedro
David
Juan Pablo
Maria Jose Pardo
If i use this function in a classic "sheet" , the fuction is working fine, but this is not working in my powerpivot table.
Who can help me?
Thanks in advance.
I hope you can help me:
Here my fonction used in the power pivot table:
=MID([DisplayName];FIND(CHAR(40);[DisplayName])+1;FIND(CHAR(41);[DisplayName])-FIND(CHAR(40);[DisplayName])-1)
Display Name
AAPP(Pedro)
AAPP(David)
AAPP(Juan Pablo).
AAPP(Maria Jose Pardo)
The target of my formula is to get this result:
Display Name
Pedro
David
Juan Pablo
Maria Jose Pardo
If i use this function in a classic "sheet" , the fuction is working fine, but this is not working in my powerpivot table.
Who can help me?
Thanks in advance.