2 Replies Latest reply: Oct 20, 2017 8:07 AM by Sunny Talwar

Simple Set Expression Required

zahid Rahim Oct 20, 2017 6:12 AM

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

Re: Simple Set Expression Required

Mark Little Oct 20, 2017 6:32 AM (in response to 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
IntervalMatch

Mark
Like Show 0 Likes (0)

Actions
Re: Simple Set Expression Required

Sunny Talwar Oct 20, 2017 8:07 AM (in response to zahid Rahim )

May be this

FirstSortedValue({<Trdate = {"$(='<=' & Date(Max(DateField), 'DD-MMM-YYYY'))"}>}Value, -Trdate)
Like Show 0 Likes (0)

Actions