Need to show minus value in brackets ()

  • Follow


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 ???

0
Reply Utf 1/15/2008 3:15:04 PM

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

-- 
KARL DEWEY
Build a little - Test a little


"Prince" wrote:

> 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 ???
> 
0
Reply Utf 1/15/2008 4:14:04 PM


1 Replies
825 Views

(page loaded in 0.064 seconds)

Similiar Articles:
















7/27/2012 2:13:10 AM


Reply: