Formatting Data

[hgg21]

Hi,

need to trouble ppl again.

In this formula field I have this:
If {ParentProduct.ParentProduct} = "Commission" then {Trade.ProdCredit}

In some records, it is zero.
May I know how to display a "-" instead of 0.00??

Thanks
Jerry

 

[jschaddock]

Jerry

In the formula field put

If {ParentProduct.ParentProduct} = "Commission"
And {Trade.ProdCredit} <> &quot;0.00&quot;
then {Trade.ProdCredit}
Else
If {ParentProduct.ParentProduct} = &quot;Commission&quot;
And {Trade.ProdCredit} = &quot;0.00&quot;
then &quot;-&quot; (or whatever you need to appear here)

 

[lyanch]

There is a much easier way to do this. Right click on the field, select Format Field, Number, Customize, Number. On the lower right hand side there is a selection for &quot;display zero as&quot;. Select the &quot;-&quot;.

Lisa

 

[hgg21]

Hi,

thanks for your reply.

Cheers
Jerry