Report template (Filter Function expression)

Hi,

I have created a report Template which looks like below,

<<[ખાતા પ્રકાર]>> Total0
     
તારીખનામવિગતપ્રકારફાઈનલ રકમ
<<Start: ORDERBY([Related Cashs], [Date])>><<[Date]>><<[Name]>><<[Detail]>><<[Type]>><<[Amount]>><<End>>

I want to add filter function where it will extract only those entries which fall between two dates (Start and End date)

For that I have created new sheet named as "Date" which contains details mentioned below Cell B2=Start Date, C2=End Date,

DetailStart DateEnd Date
Date1-Aug-202331-Dec-2023

I have used this formula but it's now working. Can someone please help me to find the error. or show me the correct expression (function)

 

<<Start: ORDERBY(FILTER("Related Cashs", AND([Date] >= [Date].[Start Date], [Date] <= [Date].[End Date])), [તારીખ])>><<[Date]>>

0 2 246
2 REPLIES 2
Top Labels in this Space