Create a list box or filter with only 2 options

[dialika_bantog]

Hi!

I wanted to create a list or app-wide filter with only two options. The options will be All and exclude 0 or null on the field. How will I be able to do that?

Cheers!

Dialika

[MindaugasBacius · Accepted solution]

I guess that impossible.

If you wish you can create this option for chosen dimensions:

1. Data that is not 0 or null

2.Data that is 0 or null

,If(Field = 0 or Len(Trim(Field)) = 0, 1, 0) as Flag

After that you will have to create two buttons:

1. All Data - it means it activates all Flag field's both values 1 and 0.

2.Exluded 0 - it mean it have to activate Flag = 1

[dialika_bantog]

Got it. Thanks heaps!