Operador Switch

principales funciones de SWITCH:

COMPARAR y crear una columna nueva

 = SWITCH (

[Month Number Of Year], 1, "January", 2, "February", 3, "March", 4, "April", 5, "May", 6, "June", 7, "July", 8, "August", 9, "September", 10, "October", 11, "November", 12, "December", "Unknown month number" )

COMPARAR IF, ELSE anidadas

= SWITCH ( TRUE, [Reorder Point] > [Safety Stock Level], "Good: Safety stock level exceeded", [Reorder Point] = [Safety Stock Level], "Minimal: Safety stock level met", [Reorder Point] < [Safety Stock Level], "At risk: Safety stock level not met", ISBLANK ( [Reorder Point] ), "Incomplete: Reorder point not set", ISBLANK ( [Safety Stock Level] ), "Incomplete: Safety stock level not set", "Unknown" )



No hay comentarios:

Publicar un comentario