Set Expression to get the remark based on amount

[#1]

Hi All,

I have below data set

ID	Remark	Amount
1	A	100
1	B	200
1	C	300
2	E	250
2	F	300

Now I want the Remark for each ID where Amount is between 200 and 300. Below is the required output

ID	Amount	Remark
1	200	B
2	250	E

[sunny_talwar]

I understand that it needs to be between 200 and 300. But is 200 considered to be between 200 and 300, but 300 is not considered to be between 200 and 300?

[#3]

200 and 300 will not be considered.

[sunny_talwar]

Then how can this be an output? I mean you don't have to respond back if you think you have found your solution. But I was just confused of how you decide the logic. Just wanted to offer my 2 cents

[Kushal_Chawda]

I am too confused

[sunny_talwar]

Glad I am not the only one

[#7]

Sunny, for my actual scenario I have another threshold which is like below

TD_Amount > 10000 and  TD_Amount < 20000 which is working fine. May be I have not put the scenario very well.

[sunny_talwar]

Sounds good. It all make sense now