8 Replies Latest reply on Oct 7, 2011 11:42 AM by AdamReed

    displaying currency symbols based other field contents

    AdamReed

      Title

      displaying currency symbols based other field contents

      Post

      I imagine this is quite a basic problem (hope so)...

      I'd like to be able to select a currency from a drop down list.  Examples are "US Dollars" "Euro" "British Pounds Sterling" etc., but I would like to display them on another layout as just the appropriate symbol: $, €, £, etc.

      I'm able to do this with just one symbol:

      If ( currency = "US Dollars" ; "$" ; "" ) 

      but don't know the syntax for doing this for more than one currency.

      If there's a better way, please let me know.

      Thanks for any help.

        • 1. Re: displaying currency symbols based other field contents
          raybaudi

          Case(
          currency = "US Dollars" ; "$" ; 
          currency = "Euro" ; "€" ;
          currency = "British Pounds Sterling" ; "£"
          )

          • 2. Re: displaying currency symbols based other field contents
            AdamReed

            That makes sense, although I'm getting "The specified field cannot be found."  The field names are correct -- they're in the same table, does that make a difference?

            • 3. Re: displaying currency symbols based other field contents
              raybaudi

               " The field names are correct "

              Why "names" ? Wasn't it a lone field ? Wasn't it currency ?

              • 4. Re: displaying currency symbols based other field contents
                AdamReed

                Perhaps I didn't explain clearly.  In the same table I have two fields: "currency" and "currency symbol".

                "Currency" has "US Dollars" etc.

                "Currency Symbol" has $, etc.

                Is this unnecessary?  Perhaps what you're suggestiing handles this in one field -- just displaying the same record differently?

                (sorry for my inexperience)

                • 5. Re: displaying currency symbols based other field contents
                  AdamReed

                  I've got it working -- I think I hadn't established a default value (not sure why that would generate the error message it did, but when I added one it seemed to fix the problem).  Thanks very much for your help!

                  • 6. Re: displaying currency symbols based other field contents
                    AdamReed

                    A follow-up question.  I am now able to display the appropriate currency symbol in it's own field box, but haven't been able to successfully display the currency symbol in a calculated or number field with:

                    currency symbol & payment amount

                    Currency symbol is derived from another field "currency", as below.

                    Is there another trick for displaying the symbol in the field with the amount (I'd prefer €1,000 rather than what I currently have: €         1,000).

                    Thanks.

                     

                    Case (

                    currency = "US Dollars" ; "$" ; 

                    currency = "Euro" ; "€" ;

                    currency = "British Pounds" ; "£" ;

                    currency = "United Arab Emirates Dirham" ; "AED" ;

                    currency = "Afghanistan Afghani" ; "AFN" ;

                    currency = "Albania Lek" ; "ALL" ;

                    currency = "Armenia Dram" ; "AMD" ;

                    currency = "Netherlands Antilles Guilder" ; "ANG" ;

                    currency = "Angola Kwanza" ; "AOA" ;

                    currency = "Argentina Peso" ; "ARS" ;

                    currency = "Australia Dollar" ; "AUD" ;

                    currency = "Aruba Guilder" ; "AWG" ;

                    currency = "Azerbaijan New Manat" ; "AZN" ;

                    currency = "Bosnia and Herzegovina Marka" ; "BAM" ;

                    currency = "Barbados Dollar" ; "BBD" ;

                    currency = "Bangladesh Taka" ; "BDT" ;

                    currency = "Bulgaria Lev" ; "BGN" ;

                    currency = "Bahrain Dinar" ; "BHD" ;

                    currency = "Burundi Franc" ; "BIF" ;

                    currency = "Bermuda Dollar" ; "BMD" ;

                    currency = "Brunei Darussalam Dollar" ; "BND" ;

                    currency = "Bolivia Boliviano" ; "BOB" ;

                    currency = "Brazil Real" ; "BRL" ;

                    currency = "Bahamas Dollar" ; "BSD" ;

                    currency = "Bhutan Ngultrum" ; "BTN" ;

                    currency = "Botswana Pula" ; "BWP" ;

                    currency = "Belarus Ruble" ; "BYR" ;

                    currency = "Belize Dollar" ; "BZD" ;

                    currency = "Canada Dollar" ; "CAD" ;

                    currency = "Congo/Kinshasa Franc" ; "CDF" ;

                    currency = "Switzerland Franc" ; "CHF" ;

                    currency = "Chile Peso" ; "CLP" ;

                    currency = "China Yuan Renminbi" ; "CNY" ;

                    currency = "Colombia Peso" ; "COP" ;

                    currency = "Costa Rica Colon" ; "CRC" ;

                    currency = "Cuba Convertible Peso" ; "CUC" ;

                    currency = "Cuba Peso" ; "CUP" ;

                    currency = "Cape Verde Escudo" ; "CVE" ;

                    currency = "Czech Republic Koruna" ; "CZK" ;

                    currency = "Djibouti Franc" ; "DJF" ;

                    currency = "Denmark Krone" ; "DKK" ;

                    currency = "Dominican Republic Peso" ; "DOP" ;

                    currency = "Algeria Dinar" ; "DZD" ;

                    currency = "Egypt Pound" ; "EGP" ;

                    currency = "Eritrea Nakfa" ; "ERN" ;

                    currency = "Ethiopia Birr" ; "ETB" ;

                    currency = "Fiji Dollar" ; "FJD" ;

                    currency = "Falkland Islands Pound" ; "FKP" ;

                    currency = "Georgia Lari" ; "GEL" ;

                    currency = "Guernsey Pound" ; "GGP" ;

                    currency = "Ghana Cedi" ; "GHS" ;

                    currency = "Gibraltar Pound" ; "GIP" ;

                    currency = "Gambia Dalasi" ; "GMD" ;

                    currency = "Guinea Franc" ; "GNF" ;

                    currency = "Guatemala Quetzal" ; "GTQ" ;

                    currency = "Guyana Dollar" ; "GYD" ;

                    currency = "Hong Kong Dollar" ; "HKD" ;

                    currency = "Honduras Lempira" ; "HNL" ;

                    currency = "Croatia Kuna" ; "HRK" ;

                    currency = "Haiti Gourde" ; "HTG" ;

                    currency = "Hungary Forint" ; "HUF" ;

                    currency = "Indonesia Rupiah" ; "IDR" ;

                    currency = "Israel Shekel" ; "ILS" ;

                    currency = "Isle of Man Pound" ; "IMP" ;

                    currency = "India Rupee" ; "INR" ;

                    currency = "Iraq Dinar" ; "IQD" ;

                    currency = "Iran Rial" ; "IRR" ;

                    currency = "Iceland Krona" ; "ISK" ;

                    currency = "Jersey Pound" ; "JEP" ;

                    currency = "Jamaica Dollar" ; "JMD" ;

                    currency = "Jordan Dinar" ; "JOD" ;

                    currency = "Japan Yen" ; "JPY" ;

                    currency = "Kenya Shilling" ; "KES" ;

                    currency = "Kyrgyzstan Som" ; "KGS" ;

                    currency = "Cambodia Riel" ; "KHR" ;

                    currency = "Comoros Franc" ; "KMF" ;

                    currency = "Korea (North) Won" ; "KPW" ;

                    currency = "Korea (South) Won" ; "KRW" ;

                    currency = "Kuwait Dinar" ; "KWD" ;

                    currency = "Cayman Islands Dollar" ; "KYD" ;

                    currency = "Kazakhstan Tenge" ; "KZT" ;

                    currency = "Laos Kip" ; "LAK" ;

                    currency = "Lebanon Pound" ; "LBP" ;

                    currency = "Sri Lanka Rupee" ; "LKR" ;

                    currency = "Liberia Dollar" ; "LRD" ;

                    currency = "Lesotho Loti" ; "LSL" ;

                    currency = "Lithuania Litas" ; "LTL" ;

                    currency = "Latvia Lat" ; "LVL" ;

                    currency = "Libya Dinar" ; "LYD" ;

                    currency = "Morocco Dirham" ; "MAD" ;

                    currency = "Moldova Leu" ; "MDL" ;

                    currency = "Madagascar Ariary" ; "MGA" ;

                    currency = "Macedonia Denar" ; "MKD" ;

                    currency = "Myanmar (Burma) Kyat" ; "MMK" ;

                    currency = "Mongolia Tughrik" ; "MNT" ;

                    currency = "Macau Pataca" ; "MOP" ;

                    currency = "Mauritania Ouguiya" ; "MRO" ;

                    currency = "Mauritius Rupee" ; "MUR" ;

                    currency = "Maldives (Maldive Islands) Rufiyaa" ; "MVR" ;

                    currency = "Malawi Kwacha" ; "MWK" ;

                    currency = "Mexico Peso" ; "MXN" ;

                    currency = "Malaysia Ringgit" ; "MYR" ;

                    currency = "Mozambique Metical" ; "MZN" ;

                    currency = "Namibia Dollar" ; "NAD" ;

                    currency = "Nigeria Naira" ; "NGN" ;

                    currency = "Nicaragua Cordoba" ; "NIO" ;

                    currency = "Norway Krone" ; "NOK" ;

                    currency = "Nepal Rupee" ; "NPR" ;

                    currency = "New Zealand Dollar" ; "NZD" ;

                    currency = "Oman Rial" ; "OMR" ;

                    currency = "Panama Balboa" ; "PAB" ;

                    currency = "Peru Nuevo Sol" ; "PEN" ;

                    currency = "Papua New Guinea Kina" ; "PGK" ;

                    currency = "Philippines Peso" ; "PHP" ;

                    currency = "Pakistan Rupee" ; "PKR" ;

                    currency = "Poland Zloty" ; "PLN" ;

                    currency = "Paraguay Guarani" ; "PYG" ;

                    currency = "Qatar Riyal" ; "QAR" ;

                    currency = "Romania New Leu" ; "RON" ;

                    currency = "Serbia Dinar" ; "RSD" ;

                    currency = "Russia Ruble" ; "RUB" ;

                    currency = "Rwanda Franc" ; "RWF" ;

                    currency = "Saudi Arabia Riyal" ; "SAR" ;

                    currency = "Solomon Islands Dollar" ; "SBD" ;

                    currency = "Seychelles Rupee" ; "SCR" ;

                    currency = "Sudan Pound" ; "SDG" ;

                    currency = "Sweden Krona" ; "SEK" ;

                    currency = "Singapore Dollar" ; "SGD" ;

                    currency = "Saint Helena Pound" ; "SHP" ;

                    currency = "Sierra Leone Leone" ; "SLL" ;

                    currency = "Somalia Shilling" ; "SOS" ;

                    currency = "Seborga Luigino" ; "SPL*" ;

                    currency = "Suriname Dollar" ; "SRD" ;

                    currency = "São Principe and Tome Dobra" ; "STD" ;

                    currency = "El Salvador Colon" ; "SVC" ;

                    currency = "Syria Pound" ; "SYP" ;

                    currency = "Swaziland Lilangeni" ; "SZL" ;

                    currency = "Thailand Baht" ; "THB" ;

                    currency = "Tajikistan Somoni" ; "TJS" ;

                    currency = "Turkmenistan Manat" ; "TMT" ;

                    currency = "Tunisia Dinar" ; "TND" ;

                    currency = "Tonga Pa'anga" ; "TOP" ;

                    currency = "Turkey Lira" ; "TRY" ;

                    currency = "Trinidad and Tobago Dollar" ; "TTD" ;

                    currency = "Tuvalu Dollar" ; "TVD" ;

                    currency = "Taiwan New Dollar" ; "TWD" ;

                    currency = "Tanzania Shilling" ; "TZS" ;

                    currency = "Ukraine Hryvna" ; "UAH" ;

                    currency = "Uganda Shilling" ; "UGX" ;

                    currency = "Uruguay Peso" ; "UYU" ;

                    currency = "Uzbekistan Som" ; "UZS" ;

                    currency = "Venezuela Bolivar Fuerte" ; "VEF" ;

                    currency = "Viet Nam Dong" ; "VND" ;

                    currency = "Vanuatu Vatu" ; "VUV" ;

                    currency = "Samoa Tala" ; "WST" ;

                    currency = "Communauté Financière Africaine (BEAC) CFA Franc BEAC" ; "XAF" ;

                    currency = "East Caribbean Dollar" ; "XCD" ;

                    currency = "International Monetary Fund (IMF) Special Drawing Rights" ; "XDR" ;

                    currency = "Communauté Financière Africaine (BCEAO) Franc" ; "XOF" ;

                    currency = "Comptoirs Français du Pacifique (CFP) Franc" ; "XPF" ;

                    currency = "Yemen Rial" ; "YER" ;

                    currency = "South Africa Rand" ; "ZAR" ;

                    currency = "Zambia Kwacha" ; "ZMK" ;

                    currency = "Zimbabwe Dollar" ; "ZWD" ;

                    "$" )

                    • 7. Re: displaying currency symbols based other field contents
                      raybaudi

                       Hi

                      those are too many cases for a calculation! It will be better to create a related table for currencies.

                      BTW: the calculation ( result text ): currency symbol & payment amount must give €1,000 and not what you say to have now. ( €         1,000 )

                      • 8. Re: displaying currency symbols based other field contents
                        AdamReed

                        Hmm, when it's used in its own field, the Case calculation seems to be working -- is it using it in the caculation of another field (currency type & payment) that might be the problem?

                        I've tried using a table, but can only seem to display the currency symbol in one of three calculated fields (I have gross foreign payment, net foreign payment, and foreign fees, all of which require the currency symbol) -- is there a rule about using a value in only one calculation per layout?