hi Laurie, Your suggestion is very useful, thanks again. My data will have numerous instances where a given agent will not have 3 observations with risk level 1 or even 2 obs with risk level 2. The challenge i believe is arriving at a program/code to assess that if higher risk (R) does not sum to 3 for a given agent, will need higher observations from lower risk level. In the want table, row 19, under agent Barb, would be looking for it to populate to 'Y', as R has only 2 obs, so need 1 more, and prefer higher risk level. agent_name action_type risk_level subject_to_review Albert 1000 1 Albert 1000 1 Y Albert 1000 1 Y Albert 1000 1 Y Albert 2100 2 Albert 2100 2 Y Albert 2100 2 Y Albert 2100 2 Albert 3230 0 Albert 2500 3 Albert 2500 3 Albert 2500 3 Albert 2500 3 Albert 2500 3 Albert 5200 Barb 1000 1 Y Barb 1000 1 Y Barb 2100 2 Barb 2100 2 Y Barb 2100 2 Y Barb 3230 0 Y Is there a way for the program you offered, to say, based on risk (R) level, for it to consider, for each given agent: if R1*3>=3, do nothing; if R1*3=2 then fetch an additional lower level R2 ... Ultimately to arrive at the following 5 obs, per risk level: R1+R1+R1+R2+R2 (Ideal scenario for a given agent) R1+R1+R2+R2+R2 R1+R2+R2+R2+R2 If full shortage of R1, compensate by getting from lower level, etc. R2+R2+R2+R2+R2 R2+R2+R2+R2+R3 R2+R2+R2+R3+R3 ... R5+R5+R5+R5+R5 Please, let me know your thoughts, Thank you very much
... View more