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

(Aparicio Piñeyrúa) #1

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) #2

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 Piñeyrúa) #3

@Bellave_Jayaram

I just try but is not working

(Bellave Jayaram) #4

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

(Aparicio Piñeyrúa) #5

@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 Piñeyrúa) #6

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