Button - only show where value not equal to zero

[danielnevitt]

Hi,

I have a calculated expression field 'DIFFERENCE':

Sum(MARGIN)-((Sum(PAY)+(Sum(COLLECT))))

I would like to create a button that the user is able to click to show where this field does not equal zero.

Thanks for any help with this.

Regards,

Daniel

[#2]

Do you need to mark non 0 rows using color or filter 0 rows from table?

[#3]

Hi Daniel,

You can create a variable, say vFilter. Set vFilter = 0.

Create a button and add the action 'Set Variable' where the variable is vFilter and the value is if(vFilter = 0, 1, 0)

Then in your table, set the background color expression of 'DIFFERENCE' to:

if(vFilter, RGB(0,200,0), RGB(255,255,255))

[danielnevitt]

Hi Dariusz,

Thank you for your reply.

I would like the button to filter the 0 rows from the table.

Regards,

Daniel