I WOULD LIKE THE REPORT TO STAY VISIBLE IF THE REQUEST UNIDADE SOLICITANTE IS BLANK
AND([Data]>=ANY(SELECT(FILTRO_Empresa[Data_Inicial],true)),
[Data]<=ANY(SELECT(FILTRO_Empresa[Data_Final],true)),
[Empresa]=ANY(SELECT(FILTRO_Empresa[Empresa],true)),
[UnidadeSolicitante]=ANY(SELECT(FILTRO_Empresa[UnidadeSolicitante],true)))
IF IT IS BLANK SHOW ALL REQUESTS ACCORDING TO THE PERIOD SELECTED ABOVE
Note: please change this to a “question”
AND(
IF(IsNotBlank(Any(FILTRO_Empresa[Data_Inicial])),
[Data] >= Any(FILTRO_Empresa[Data_Inicial]),
true),
IF(IsNotBlank(Any(FILTRO_Empresa[Data_Final])),
[Data] <= Any(FILTRO_Empresa[Data_Final]),
true),
IF(IsNotBlank(Any(FILTRO_Empresa[Empresa])),
[Empresa] = Any(FILTRO_Empresa[Empresa]),
true),
IF(IsNotBlank(Any(FILTRO_Empresa[UnidadeSolicitante])),
[UnidadeSolicitante] = Any(FILTRO_Empresa[UnidadeSolicitante]),
true)
)
The basic idea is this:
AND()
statement, becomes the equivalent of “skip this step”So each “branch” only uses the logic if there’s a value for that logic to run on; otherwise they all result in NO filter
(adjust as you see fit)
I would like to thank (MultiTech_Visions) , the formula worked.
Thank you!
User | Count |
---|---|
30 | |
26 | |
24 | |
21 | |
21 |