Conditional Suppression based on other fields

[jlr123]

I am modifying a report that I did not create. I have a field that I want to suppress if three other fields are blank. What is the syntax for the conditional suppression? I know where to put the formula, however there is a formula already there for something else. Is that a problem?

Thanks for your help.

 

[LaurieHamlin]

If you need to leave the existing formula there, it can be worked around. Is it also a suppression formula?
If yes add to it. ex. if it's
If {field Z} = "XYZ" Then
True
Else
False

make it
If {field Z} = "XYZ" Or if IsNull({field A}) Then
True
Else
False

 

[jlr123]

Understood but still having issue with the or if isnull condition for the three other fields.I am missing some syntax I am sure.

This is the first suppression
formula = {AR_CashExpectationReportWrk.InvoiceType} in array ("CM", "PY")

The second is the condition I need -or if isnull:
or if isnull
({AR_CashExpectationReportWrk.PaymentAmt1} and {AR_CashExpectationReportWrk.PaymentAmt2}
and {AR_CashExpectationReportWrk.PaymentAmt3} and {AR_CashExpectationReportWrk.PaymentAmt4}) then true else false

thanks again.

 

[LaurieHamlin]

The "and" means they all have to be null. Do you want it suppressed only if all are null or if any are null?
What field types are PaymentAmt1, PaymentAmt2, PaymentAmt3 and PaymentAmt4? If they're set as currency it would have to be
If PaymentAmt1 < $0.01

if they're string it would be
PaymentAmt1 < " "

I hope that helps.

 

[jlr123]

Ok I found how to suppress at the format field level. And it works the way it should as far as suppression goes. HOWEVER, now I have a lot of blank space between my details of one record and total for that record. How can I get rid of the blank space?
The following is the suppression formula

({AR_CashExpectationReportWrk.PaymentAmt1}=0.00)and ({AR_CashExpectationReportWrk.PaymentAmt2}=0.00)and ({AR_CashExpectationReportWrk.PaymentAmt3}=0.00)and ({AR_CashExpectationReportWrk.PaymentAmt4}=0.00)

 

[jlr123]

I have found the answer! I had to suppress at the Section level.

Thanks all.