Convert Numeric Text to Dollars

[szeiss]

I'm using CR 8.5. I have a formula that displays the value without any decimals when table.rpt <> 4. When table.rpt equals 4 then I want to see the decimal places. The code below works, BUT I need to add the dollar sign in the first instance, but so far no luck. Both of these fields are numeric.

If {table.RPT} <> 4 Then
  ToText({table.ACTUALS}, 0)
Else
  ToText({table.ACTUALS}, 2)

Thanks,
Sherry

 

[elsenorjose]

You might try concatenating the dollar sign to your first value:

If {table.RPT} <> 4 Then
  "$"&" "&ToText({table.ACTUALS}, 0)
Else
  ToText({table.ACTUALS}, 2)