title: Formatting data in Crystal Reports
body: <p>I have a field which is a Double. For display on a the report, if that value is negative, then I need to reverse the number by multiplying it by -1. The result should be formatted like this: "(1,000)" (notice no "-" sign). How can I do this in Crystal? I was using a Display String formula to try to do this since the "Reverse sign for display" option doesn't work for me (because it needs to be a formula for other reasons).</p>
  
  <p>So far I have:</p>
  
  <pre><code>if {columnName} &lt; 0 then
    "(" &amp; ToText({columnName}, "#,###", 0) &amp; ")"
  else
    "(" &amp; ToText({columnName} * -1, "#,###", 0) &amp; ")"
  </code></pre>
  
  <p>But this gives me something like this: "(-6,500)", and I need to get rid of that pesky minus sign.</p>
  
  <p><strong>Edit:</strong><br>
  I implemented a formula field like this:</p>
  
  <pre><code>-Abs({columnName})
  </code></pre>
  
  <p>Then selected the format that looks like (1,234) from the format list as Craig answered below.</p>