cancel
Showing results for 
Search instead for 
Did you mean: 

Currency, UOM question

Former Member
0 Kudos

Hi Gurus,

I have following questions..pl.reply..

We have sales document in various currencies need to be reported in USD or EURO on basis of currency selected in the report.

How this is achieved in Crystal when the reproti s generated on BI cube.

Also the total sales need to shown in KD, LB depending the selection done in execution of report. How to convert the various units maintained to common currency in Crystal.

Appreciate the reply..

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

ManiIyer,

How are your sales figures currently stored? Are they converted to a common currency at the time of entry, or are they stored in their original amounts with a separate field indicating the currency type?

To alter the currency symbol...

1) Right click your currency field and choose Format Field.

2) On the Number tab, click the Customize button.

3) Choose the Currency Symbol tab.

4) For the Currency Symbol: enter a formula similar to this...


IF {Table.CurrencyType} = "Euro" THEN "u20AC" ELSE "$"

5) You can also do the same thing with the position property...


IF {Table.CurrencyType} = "Euro" THEN crTrailingCurrencyInsideNegative ELSE crLeadingCurrencyInsideNegative

I have no idea what you are referring to when you say "shown in KD, LB", so I can't help you there...

Due to constantly changing exchange rates, CR doesn't maintain current conversion tables. You will have to bring that data in from an outside data source, preferably your database or datawarehouse. Once you have the conversion rate for the 2 currencies, just do the math in a formula.

HTH,

Jason

Former Member
0 Kudos

The sales data is entered in various UOM( Unit of measurement) in sales document..

On the basis of selection criteria in report, the sales summary has to be shown in KG(kilo) or LB( Pound).

How to ensure that various unit of measure is converted to KG, or LB at the time of execution report?

Thanks to let me know..

Former Member
0 Kudos

Ok... So If I'm thinking this through correctly, you have 2 parameters... Currency & Unit of measure.

The LB vs KG issue is easy there is exactly 2.2 lbs per kilo (2.20562262 to be precise) so that's an easy conversion from 1 to the other.

So assuming that the UOM is based on the metric system (kilos), you can write a formula similar to this...


IF {?UOM} = "Pounds" THEN {table.weight} * .45359237 ELSE {table.weight}

The currency issue is a little different due to the fact that exchange rates fluctuate, so you can't hard code the value...

How the exchange rates are stored will determine the best way to retrieve them.

1st consideration... Do you want to convert the currency based on the date of sale or on the most current exchange rate?

2nd consideration... How are the exchange rates stored in your database? If they are not stored in your database, where do you plan on getting the exchange rates?

Jason

Answers (0)