I am making a Purchase Order Confirmation and I have three fields in the report that sometimes have data and sometimes don't have depending on the purchase order.

 

ContractNo:                 VenPartNum                     PartNum

0008                           121212                            0128101

 

Sometimes ContractNo does not have the data in it, so what I'm aiming to do is to show the PartNum in the ContractNo field if ContractNo is empty then don't show the PartNum at all. So it should look something like this.

 

so instead of having the ContractNo empty, it will be filled with the PartNum and the PartNum won't exist at all.

 

I know it's simple but I get confuse of using the IF statement..

 

What I did is, I created a new Formula Field and put this formula in:

 

 

there's no error but it's not giving me the result that I expected to see.

 

Please help :)

 

 

 

 

 

where do i put these two formulas in?

 

i put the first formula in the existing ContractNo field (display)..not sure where to put the 2nd one though (suppression). So I made a new formula field and put this suppression formula in it, named it as "ContractNoLabel", dragged it in the report but what I get is a "false" result.. :(