How to Remove - (Minus) Symblos before values

Question

Iam using SQL server 2008.I had Developed the reports Using Business Intelligence studio .I had developed several reportshe . In one of the report the report values are getting - symbol.So I want remove the the (-) symbols.

Example:- -2344.00 

Is it Possible to add expression and remove the - symbol.

 

Answer 1

You have a few options.

1) If the data is coming from a dataset, do the formatting at the datalevel.

2) If the values are all numbers, you could use: =ABS(-2100.00)

3) If the valures are strings you could use: =Replace(-2100.00,"-","")

---

every day is a school day

Answer 2

How about

=IIF(@number < 0, @number*-1,@number)