6 Replies Latest reply on Apr 18, 2018 4:11 AM by mausami sharma

    How Do I create a Currency Conversion parameter?

    Andrew Ryan

      How Do I create a Currency Conversion parameter? I have my data from one source in dollars, and my currency data from an excel file. I am already connected to both sources, but can't seem to get the parameter or calculated field right.

       

      I need my [COST] field to multiply times the currency rate [RATE] when I switch to the desired currency in my parameter. The currency data is organized like this:

       

      Currency Code          Currency Name          Rate

      SGD                              Singapore Dollar         1.36

      JPY                              Japanese Yen              111.75

       

      Can somebody help me with the steps to create the parameter and the calculated field to convert my data from dollars to the desired currency?

       

      Thanks,