Date Conversion

[BadPenguin]

I am needing to write a report that essentially is a receipt. Our database stores a discount as a string. Depending on if the discount is a percent or dollar amount, the date is stored with a preceding identifier. For example:

$10 for a dollar amount discount
%15 for a percentage discount.

How can I check for the type of discount in crystal reports and then based on the type of discount, convert it to a useable number (basically strip the beginning character once it is identified)

Thanks for any help offered.

 

[lbass]

Try:

if left({table.string},1) = "$" then tonumber(mid({table.string},2)) else
if left({table.string},1) = "%" then tonumber(mid({table.string},2))/100

-LB

 

[BadPenguin]

Thanks so much, worked like a charm

BP