Need to show minus value in brackets ()

P

Prince

Hi,
I am making a report with different text fields one text fields is
calculating variance which I need to print in brackets instead of "-" sign.

Any suggestions please ???
 
K

KARL DEWEY

Calculating Variance: IIF([YourField] <0, "("& Abs([YourField]) & ")",
[YourField])
 
Top