ITEM formula for on flat list

Options
CommunityMember117741
CommunityMember117741 Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

Hi, I have two modules (see pictures). The Attainment Employee Position Check module checks which positions an employee has during the current planning year and the Attainment Employee Active Position Check module will use the information used in the previous module. So in the example below an employee named TBH has the position Channel Manager 3 - Australia starting 2020-jan-01 and ending the postion 2020-feb-29. Based on this logic the Boolean in the other module should be TRUE for Jan and Feb, for Channel Manager 3 - Australia.  I am trying to build some logic [item('FL-Position') = First Position AND Start>= Fist Position Start Date AND End() <= First Position End Date), but, since both the employee list and position list used in these modules are flat lists i cannot use ITEM. Does anyone know a workaround this issue? 

 

Kind regards

 

CommunityMember117741_0-1589228819294.png

CommunityMember117741_2-1589228953794.png

 

 

 

Tagged:

Comments

  • CommunityMember117741
    CommunityMember117741 Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Contributor

    The previous build was in levels, but, due to the number of levels in the hierarchy the build became to complicated for the clients.  An employee can have up to three positions under a given year (not at the same time). This solution will be a little ugly, but, easier for the client to understand. 

     

    Looking at Anapedia it says the list needs to be in a hierarchy.  I get an error message: "FL-Position is not recognized as a hierarchy in the model. The item function should take a hierarchy as argument"

    CommunityMember117741_0-1589255493696.png

     

  • CommunityMember117741
    CommunityMember117741 Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Contributor

    Thank you! There was one more "space" i was missing. Now it works. 

     

     

Categories