Hello,

Using Crystal Reports 10

I'm trying to use different formats for different currencies. For example. $15,000 and 15,000EUR.

I have these two formulas


For Currency Position
if {eaSPSelDealPayoutByDateRangeInitialQry;1.Currency } = "USD" Then
1
else
3

For Currency Symbol
if {eaSPSelDealPayoutByDateRangeInitialQry;1.Currency } <> 'USD' Then
{eaSPSelDealPayoutByDateRangeInitialQry;1.Currency }
else
'$'


I have 3 fields that would use this formula, one Numeric and two currencies. The formula works as expected in the Number but not in the Currency.

Any ideas on why this is happening?

Thanks!