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

[Kushal_Chawda · Accepted solution]

Create the straight table

Dimension:

ID

Remark

Expression:

=sum({<Remark ={"=Sum(Amount)>200 and Sum(Amount)<300"}>}Amount)

[vikasmahajan]

=sum({<Remark ={ 'B','E' }>}Amount)

[#4]

I want the Remark based on amount where amount is between 200 and 300

[kkkumar82]

As per kush this is what you will get

[_armoco_]

Hi,

When you say between 200 and 300 does it include the upper and lower limit values as well?

In the sample output you provided, you've included the lower limit of the Amount value(200) however you didn't include the upper limit value(300)....

Anyway, using distinct in the back-end,  Amount>=200 and Amount<300 in the front-end, I could come up with this:

Is this what you wanted?

[Anonymous]

may be like this?

Dimesnion: ID, Remark

Expression: sum(if(Amount>200 and Amount<300, Amount))

[_armoco_]

Hi,

This also seems to work:

Thanks and Regards,

Arjun

[sunny_talwar]

When you say between 200 and 300 does it include the boundary values 200 and 300 or not? Why did you include B for ID 1 and exclude C for the same ID?

Similarly, you excluded F for ID 2

What would happen if you have something like this

ID, REMARK, AMOUNT

3, G, 300

3, H, 400

Would you now pick ID 3 and remark G or you won't?

[#10]

No sunny, I wont pick that, I just want the ID or remark where Amount is in between 200 and 300.