Problem with EXCEL template

[mateo]

Hi there,
When I put that expression:

<<Start: Filter(Table_name, AND(OR
([B]="STH";[B]="STH")
;[Y]=TODAY();
[Z]="Yes"
))>><<[A]>>

into the template table in R1C1 cell i get this:

<<templateReference:id=1>>

Any ideas?

[APiCC_Conor · Accepted solution]

I often get that result when my start expression retrieves zero results.

You can double check by creating a temporary virtual column using the start expression to see if it also produces zero results.

[mateo]

Exactly that was the reason, thanks a lot. I thought maybe there is sth wrong with my expression.

[EtaEfendi]

I have the same problem with the template  (<<templateReference:id=1>>). Would you explaine for more detail?

There is my template table, [Jml. Rekam Data] is the references table. And the result is <<templateReference:id=1>>