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
