I know this question has been asked and answered but I am really struggling to get my 'hide object' formula working.
I have a 'DEALS' table with three fields I am trying to reference to either hide or show an object. These formula I am using is:
( DataFile_DEALS::Deal_ActiveStatus ≠ "Settled" )
( DataFile_DEALS::Income_Lender_ExGST = "" )
( DataFile_DEALS::Income_Lender_DatePaid ≠ "")
The logic I am aiming for is that the object needs to be hidden if the fields have the following conditions:
DataFile_DEALS::Deal_ActiveStatus does not contain the value "Settled" (this is a text field)
DataFile_DEALS::Income_Lender_ExGST does not contain a value (this is a number field)
DataFile_DEALS::Income_Lender_DatePaid contains a value (this is a date field)
Another way of wording the logic is to show the object when the values are as follows:
DataFile_DEALS::Deal_ActiveStatus is 'Settled"
DataFile_DEALS::Income_Lender_ExGST is not empty
DataFile_DEALS::Income_Lender_DatePaid is empty
How would I be able to hide the object based on the above?
Thanks in advance for any assistance