cancel
Showing results for 
Search instead for 
Did you mean: 

Formatting currency using display string

Former Member
0 Kudos

I have a currency that I need to display negatives with a CR at the end. I formatted the currency with the following formula in the display string.

if {BillHeader.Payments} < 0 then
     formula = CStr ({BillHeader.Payments}) + "CR"
else
     formula = CStr ({BillHeader.Payments})
end if

My problem is I converted the currency to string. I can't take out Crystal's formatting for the negative. As an example result I'll get:

$(57.00)CR

when I need it to look like:

$57.00CR

Is there any way to get rid of the parenthesis within the display string formula? I don't know very much VB so I hope this is easily fixed. Thank you.

Edited by: MarcieHennessy on Nov 12, 2009 11:23 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The easy way would be to simply convert it back into a positive number...


if {BillHeader.Payments} < 0 then
     formula = CStr (-1 * {BillHeader.Payments}) + "CR"
else
     formula = CStr ({BillHeader.Payments})
end if

Hope that helps,

Jason

Answers (0)