Hi, I’m in need of help on this formula. I would like to make a free filter , for each selection bring me the information and multiple selections filter too
Try this:
AND(
OR(
ISBLANK([DataInicio]),
ISBLANK(Data[DataIn]),
([DataInicio] >= MAX(Data[DataIn]))
),
OR(
ISBLANK([DataFinal]),
ISBLANK(Data[DataOut]),
([DataFinal] <= MIN(Data[DataOut]))
),
OR(
ISBLANK(Data[StatusVista]),
IN([StatusVista], Data[StatusVista])
),
OR(
ISBLANK(Data[NomeFuncionarioDT]),
IN([NomeFuncionarioDT], Data[NomeFuncionarioDT])
),
OR(
ISBLANK(Data[Equipe]),
IN([Equipe], Data[Equipe])
)
)
See also:
2 Likes
Hi, how can I filter within the [REF_OrdemProducao] the [Desenh.o] that is part of the OrdemProducao and the [Pec.a] that is part of the [Desenh.o] ?
I do not understand your question.
sorry , really the question would not be valid for the application

