Expression Generating Empty report

<<Start: Select(Invoice[Row ID], AND([Date] >= [_THISROW].[From], [Date] <= [_THISROW].[To], [Service Name].[Category] = "Visit charge", [Service Provider].[Status] = "Visiting"))>>

This above expression is generating an empty report. for e.g.

Jayraj9593_0-1730712055731.png

Here is the template expression for reference.

Jayraj9593_0-1730712353101.png

 

 

Please let me know what is wrong with the expression.

 

 

 

0 1 46
1 REPLY 1

Steve
Platinum 5
Platinum 5

Your SELECT() expression isn't finding any matching rows.