how to hide minus(-) sign on report

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  August 27, 2008 at 1:47 am

  #191667

  hi guys,

  I m doing substraction of 2 values.but if there is amount in first value is 0 or less than second amount then final result set shows negative value.and amount never negative.So i want how to do supress the - sign on report?:P

• abhijeetv

  SSCommitted

  Points: 1945

  More actions

  September 16, 2008 at 7:50 am

  #872379

  Use abs(firstvalue-secondvalue) in your query to get the absolute value instead of with - sign.