locked
How to Remove - (Minus) Symblos before values RRS feed

  • 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.

     

    • Moved by Andre N. - MSFT Tuesday, August 31, 2010 6:22 PM Not a WPF question (From:Windows Presentation Foundation (WPF))
    Tuesday, August 31, 2010 7:09 AM

Answers

  • 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
    • Proposed as answer by pplcallmepsycho Wednesday, September 1, 2010 11:01 AM
    • Marked as answer by Jerry Nee Monday, September 13, 2010 2:50 AM
    Wednesday, September 1, 2010 9:14 AM

All replies

  • 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
    • Proposed as answer by pplcallmepsycho Wednesday, September 1, 2010 11:01 AM
    • Marked as answer by Jerry Nee Monday, September 13, 2010 2:50 AM
    Wednesday, September 1, 2010 9:14 AM
  • How about

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

    Wednesday, September 1, 2010 1:18 PM