Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you need to mark non 0 rows using color or filter 0 rows from table?
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))
Hi Dariusz,
Thank you for your reply.
I would like the button to filter the 0 rows from the table.
Regards,
Daniel