I wanted to display the most recent count between date ranges .... IF I select to arrange the record may bot have the rank =1 but maybe rank 3 in that date range. I need to display the record that is latest based (rank column have values including all records into consideration). I have attached my solution,, could you please help how to achieve the values?
=count(if(Date>=vStartDate and Date<=vEndDate and rnk=1 ,KeyProfile)) ..if I use this condition I'm missing records that created within date range.. so I need to get the most recent rank by selected date range.
