Hello there! I had this rule in a Doc templat...

[Aparicio_Pineyr]

Hello there! I had this rule in a Doc template:

<<Start:ORDERBY(FILTER(Lista Nueva, AND(MONTH([Fhoy])=MONTH(TODAY()),YEAR([Fhoy])=YEAR(TODAY()))),[Faltas],true)>><<[Año]>>

And I need to only show in the report all the rows that have this condition in this column [Faltas]=>3.

How can I change the formula to fullfill this need?

Thanks!

Apa

[Bellave_Jayaram]

Did you try this?

<<Start:ORDERBY(FILTER(Lista Nueva, AND(MONTH([Fhoy])=MONTH(TODAY()),YEAR([Fhoy])=YEAR(TODAY())), [Faltas]=>3),[Faltas],true)>><<[Año]>> Translate

[Aparicio_Pineyr]

@Bellave_Jayaram

I just try but is not working

[Bellave_Jayaram]

You could try a double filter then, something like filter(filter(…),=>3),true) Or SELECT (filter(…),[_THIS]=>3),true)

[Aparicio_Pineyr]

@Bellave_Jayaram

I try this with SELECT and FILTER at the begainin of the fomrmula but is not working.

<<Start:FILTER(FILTER(Lista Nueva, AND(WEEKNUM([Fhoy])=WEEKNUM(TODAY()),YEAR([Fhoy])=YEAR(TODAY()))),[Faltas],true),[Faltas]=>3),true)>><<[Año]>>

[Aparicio_Pineyr]

@Bellave_Jayaram Also, how can I add the column headers in each page of the PDF report?