Where Condition in List Box

[vinaykotha]

Hello,

I have 2 Fields ID & Description. There are 8 ID's from 1 to 8 and have descriptions for each ID. I do now want to show ID 6 in the list. Could someone please help me in writing the Where condition in the List Box. I tried several combinations but it is not working.

Thanks

Vinay K

[sunny_talwar · Accepted solution]

May be like this

If(ID <> 6, ID)

or

Aggr(Only({1<ID =-{6}>} ID), ID)

[vinaykotha]

Thank you, it worked.

[jhonesnow]

---

@vinaykotha wrote:

Hello,

I have 2 Fields ID & Description. There are 8 ID's from 1 to 8 and have descriptions for each ID. I do now want to show ID 6 in the list. Could someone please help me in writing the Where condition in the List Box. I tried several combinations but it is not working.

Thanks

Vinay K  custom boxes

---

yes man i was also trying to do that but it didn't work if you have found the solution please do help me too