How to display decimal digits based on country

[Former Member]

Hi Every one i have an issue in crystal report.

I need to display decimal digits based on country .

Ex:
kw  1.000
uk    1.00
us     1.0
hk      1.0000

currency Table:

currency id          currency code         decimal digits         currency locale          description          pattern

     1                         kw                              3                         kw                              kw               #0.000

     2                         Ae                              2                         Ae                              Ae               #0.00

Like this number of rows there

Country table:

country id          currency id          country code          country name         varient          language    

1                              1                         kw                    kuwait                    us               en

Like this number of rows there

can any one please tell me the formua for this

[abhilash_kumar · Accepted solution]

Hi Divya.

Right-click the field and select Format Field > Number tab > Customize button > Number tab >

Click on the formula button beside "Decimals:" and use this formula:

if {currency id} = 1 then 3

else if

{currency id} = 2 then 4

else if

{currency id} = 3 then 2

Hope this helps!

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces