how to hide minus(-) sign on report

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  August 27, 2008 at 1:46 am

  #189764

  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?

• nigel.c.west

  Hall of Fame

  Points: 3468

  More actions

  August 27, 2008 at 4:12 am

  #863591

  If all you want to do is to suppress the negative then you can set the value to it's absolute value by the following expression:

  =ABS(Fields!FieldName.Value)

  This will convert any negative number to a positive number.

  Note that this will also apply to any totals/sub-totals of this column.

  Regards,

  Nigel West
  UK