Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Got it. Thanks heaps!