Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I have below mentioned data where i want to extract one value based on a filter date.
Value Trdate
10 01-JAN-2017
5 01-APR-2017
4 01-MAY-2017
9 01-JUN-2017
3 01-JUL-2017
2 01-AUG-2017
7 01-SEP-2017
If the filter date is 30-JUN-2017 Then it should give only one value 9 on 01-JUN-2017
If the filter date is 31-MAR-2017 THEN it should return 10 on 01-JAN-2017
I mean the previous date value from the filter date
Regards,
Zahid Rahim
Hi zahid,
I think you would have to take a look at interval match function in script, that why you can create a link in your data for the date gaps.
Have a look at the below
Mark
May be this
FirstSortedValue({<Trdate = {"$(='<=' & Date(Max(DateField), 'DD-MMM-YYYY'))"}>}Value, -Trdate)