Forum Discussion
Syndicate_Admin
Administrator
2 years ago¿Quieres ver dentro de GOALIMIT ROW?
Hola a todos, Solo quiero ver una fila por LEMNUM - dentro de GOALIMIT cuando LEMNUM es del mismo color - en AZUL A modo de ejemplo LEMNUM 322185 - LINE_COST 279,000>250,000 y 279,000<=500,000 por...
- 2 years ago
Muchas gracias por su tiempo
Syndicate_Admin
Administrator
2 years ago@ABC11
Para ser claros, cuando tienes una sola línea con los nombres de los aprobadores concatenados, no estoy seguro de cómo te ayudará con el envío de correos. Por favor, compruebe y confirme, mejor si pudiera compartir el resultado esperado con sus datos de muestra.
Syndicate_Admin
Administrator
2 years agoHola Fowmy,
Gracias por su tiempo
Datos de muestra
| GRUPO DE PERSONAS | VENDOR_NAME | CNRCMSNUM | LEMNUM | WAPPR_DATE | CNRGOALIMIT | LINE_COST | NO_OF_DAYS | PERSONID |
| LMU216 | NOS | R024292 | 321773 | 1/8/2024 | 250,000.00 | 23,543.52 | 3 | SIERRA |
| LMU216 | NOS | R024293 | 321773 | 1/8/2024 | 250,000.00 | 23,543.52 | 3 | BLAQUETE |
| LMU216 | NOS | R024294 | 321773 | 1/8/2024 | 250,000.00 | 23,543.52 | 3 | CHRISCOM |
| LMU216 | NOS | R024295 | 321773 | 1/8/2024 | 25,000.00 | 23,543.52 | 3 | CRAIGHOO |
| LMU216 | NOS | R024296 | 321773 | 1/8/2024 | 250,000.00 | 23,543.52 | 3 | DANSO |
| LMU216 | NOS | R024297 | 321773 | 1/8/2024 | 2,500,000.00 | 23,543.52 | 3 | JASONTA |
| LMU216 | NOS | R024298 | 321773 | 1/8/2024 | 250,000.00 | 23,543.52 | 3 | JOHN |
| LMU216 | NOS | R024299 | 321773 | 1/8/2024 | 250,000.00 | 23,543.52 | 3 | ESTEBAN |
| LMU216 | NOS | R024300 | 321773 | 1/8/2024 | 100,000.00 | 23,543.52 | 3 | WESLEYWE |
| LMBP08 | FMAM | R018007 | 322447 | 1/10/2024 | 100,000.00 | 150,150.00 | 1 | ANDREWC |
| LMBP08 | FMAM | R018008 | 322447 | 1/10/2024 | 250,000.00 | 150,150.00 | 1 | BLAQUETE |
| LMBP08 | FMAM | R018009 | 322447 | 1/10/2024 | 250,000.00 | 150,150.00 | 1 | CHRISFAU |
| LMBP08 | FMAM | R018010 | 322447 | 1/10/2024 | 250,000.00 | 150,150.00 | 1 | DANSO |
| LMBP08 | FMAM | R018011 | 322447 | 1/10/2024 | 50,000.00 | 150,150.00 | 1 | DANTEC |
| LMBP08 | FMAM | R018012 | 322447 | 1/10/2024 | 250,000.00 | 150,150.00 | 1 | GREGMA |
| LMES | DEJAR | R024683 | 322925 | 1/10/2024 | 10,000.00 | 200,000.00 | 1 | HEATHECO |
| LMES | DEJAR | R024684 | 322925 | 1/10/2024 | 250,000.00 | 200,000.00 | 1 | JOHP |
| LMES | DEJAR | R024685 | 322925 | 1/10/2024 | 250,000.00 | 200,000.00 | 1 | ROBERRIT |
SALIDA
| GRUPO DE PERSONAS | VENDOR_NAME | CNRCMSNUM | LEMNUM | WAPPR_DATE | CNRGOALIMIT | LINE_COST | NO_OF_DAYS | PERSONID |
| LMU216 | NOS | R024295 | 321773 | 1/8/2024 | 25,000.00 | 23,543.52 | 3 | CRAIGHOO |
| LMBP08 | FMAM | R018008 | 322447 | 1/10/2024 | 250,000.00 | 150,150.00 | 1 | BLAKETA; CHRISFAU;|DANSO;|GREGMA |
| LMES | DEJAR | R024684 | 322925 | 1/10/2024 | 250,000.00 | 200,000.00 | 1 | JOHP; ROBERRIT |
Muchas gracias