Using a button to deslect a value

[#1]

Hi  -

I have a very long list of values representing the profit at various accounts rangeing from large negative to large positive values.

I am trying to create a button object to select all values for profit except those accounts with a profit of $0.00.

I tried the Select Excluded action with the following expression:  =profit=0

I also tried the Select in Field action with the following expression:  =profit<>0

Neither of these seem to do anything.

Thanks,

Mike

[Anonymous]

Hi Mike,

Try creating a Select In Field action.

Set the Field to Profit and set the search expression to: <0>0

This should select all but 0

[#3 · Accepted solution]

Dear,

Mike.

Kindly find the attachment with example.

Thanks,

Mukram