Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to use calculated dimension for a business requirement. The idea is to change the member name to Staff for a few employer name, rest should be same.
Employer Name: Member Name: Error Count
123 Staff 3
124 abc 5
125 cdc 6
128 Staff 10
124 xyz 11
If i use if statement in the condition it only takes one value for Employer Name.
eg: =if([Employer Name]= ('123'),'Staff ',[Member Name])
i want to add few more Employer name whose member name should reflect staff.
Any Suggestion??
Regards,
H
Hello.
With the Match command work for you:
If (match([Employer Name],123,128),'Staff',[Member Name])
John.
see the attached file
hope this helps
Hello.
With the Match command work for you:
If (match([Employer Name],123,128),'Staff',[Member Name])
John.
Hi Sunil,
Here I want the calculated dimension because I want to hide the Employee Name as Staff for the Employer Name = 123,128 so on rest should show the original Employee name.
I hope this makes it more clear.
yes
you ca write below in dimension in attached file
=If (match(EmployerName,123,128),'Staff',MemberName)
hope this helps