Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello my dears.
Currently I have one object in my document which its main goal is to represent the stores that do not have any data during the current month.
I achieve this by using the following expression in a table:
=Isnull(Max({<Año = {$(=Max(Año))}, Num_Mes = {"$(=Max({<Año = {$(=Max(Año))}>} Num_Mes))"}, Id_Canal={4}, Id_Clasificacion={1,2}, Id_Modelo_Negocio-={6},
Id_Transaccion -= {0}>} Num_Mes))
The "-1" value is replaced by a "Traffic Light Gauge". The object is functioning correctly. The problem is that I need to replace the red dot by a blue one under 2 conditions:
1. The day of the week must be sunday
2. The stores must be included in a set that I could define in a set analysis expression.
¿How can I achieve this? ¿Is it possible?
I Attached the document, You can browse it using the user "DireccionTH" and the password "Adth1106"
Hi,
Try this
if(match(Isnull(Max({<Año = {$(=Max(Año))}, Num_Mes = {"$(=Max({<Año = {$(=Max(Año))}>} Num_Mes))"}, Id_Canal={4}, Id_Clasificacion={1,2}, Id_Modelo_Negocio-={6},
Id_Transaccion -= {0}>} Num_Mes)) <0 ) , red(),
blue() )