Is Something Wrong With my Role List? Level 1

sosunkwo
Frequent Contributor

Re: Is Something Wrong With my Role List? Level 1

@aashca9 

 

Tried that too, I got this error message: 

 

'All Roles' is not valid for the name of the top level item of Role. 'All Roles' clashes with the name of an existing List Member. 

 

However, no other list goes by the name "All Roles", so I'm confused as to where the 'clashing' is happening. 

CommunityMember127535
New Contributor

Re: Is Something Wrong With my Role List? Level 1

Hi @sosunkwo - I have been stuck on the exact same problem you had "Role List Problem" And can't seem to find an answer anywhere. Did you ever get to find a workaround for this? Thank you in advance! 

SatyamArora
Frequent Contributor

Re: Is Something Wrong With my Role List? Level 1

@CommunityMember127535 can you share screenshot and the problem/error you are facing, I can try to help..

CommunityMember127535
New Contributor

Re: Is Something Wrong With my Role List? Level 1

Thank you @SatyamArora Please see more detailed info below as well as an screenshot. 

 

Original Formula:

IF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0

 

New Formula: 

IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

 

When I enter the new formula the attached Error Pops up. 

SatyamArora
Frequent Contributor

Re: Is Something Wrong With my Role List? Level 1

Try to think which all line items do you need to apply this formula to, is it asking you to lookup specific .... related to employees

sosunkwo
Frequent Contributor

Re: Is Something Wrong With my Role List? Level 1

Hi, @CommunityMember127535 , let me know if you figured it out from others' response. If not, I'd be happy to help. 

CommunityMember127535
New Contributor

Re: Is Something Wrong With my Role List? Level 1

Hi! I was actually able to solve with some help from the Community. Thank you anyways!
sosunkwo
Frequent Contributor

Re: Is Something Wrong With my Role List? Level 1

Hi, @CommunityMember127535

Happy to hear that! Cheers.
SaiArpithaRavi
New Contributor

Re: Is Something Wrong With my Role List? Level 1

Can you please share the solution even I am facing same issue

JaredDolich
Moderator

Re: Is Something Wrong With my Role List? Level 1

@sosunkwo 

Because the file you loaded included a "Parent" column. Since there's no parent (top level, in this case) you will get the error.

Your choices are to add a top level that matches the parent value in your input file or don't load the parent column.

Either of those will clear up your error!

 

Let me know what you end up doing. Just curious.


Jared Dolich