Currency Page Selector/Filter

Contributor

Currency Page Selector/Filter

Hi, 

 

I need to be able to create a DB that allows me to choose what currency to display. At the moment I have data in various currencies, a currency conversion module has been made which hosts GBP, Local Currency and USD. I've created the FX List. What I need to do now is on the dashboard somehow create a page selector that allows me to choose a currency. When I choose that currency I should see the data table change to display that. I think i'm missing a few steps, not sure how to proceed. 

 

 

 

 

5 REPLIES 5
Community Boss

Re: Currency Page Selector/Filter

@hina1994 ,

 

If the module containing the data is dimensionalized by Currency, you should be able to sync it with the page selector.

Message 2 of 6
Contributor

Re: Currency Page Selector/Filter

@rob_marshall 

Not sure how that would work. Currency converter is in a separate module to where my data tables are hosted. 

Message 3 of 6
Community Boss

Re: Currency Page Selector/Filter

@hina1994 ,

 

Correct, you have your currencies in a list by Time and you have your inputted data in a different module.  For the reporting module, you will need to dimensionalize it by the Currency list, by Time, and if you have Entity or Product.  Your line item would be Currency Module.Data * Inputted Data Module.Data.  By doing this, it will automatically find the correct currency when doing the conversion as well as allowing you to sync the data.

 

2019-06-20_11-13-20.png

 

Message 4 of 6
Highlighted
Contributor

Re: Currency Page Selector/Filter

Hi @rob_marshall , 

 

That makes sense.  I'm getting stuck on selecting the currencies. 

 

currency issue.PNG

Message 5 of 6
Community Boss

Re: Currency Page Selector/Filter

@hina1994 ,

 

Not sure why you need Conversion Year, Month, and Week when you are only showing the Year value.  With that said, you don't need line items for conversion for each currency, just one, and then let the system do the work for you.  Your formula should be 'Closing Stock Value * Sys Currrency.Data (assuming your currency module is named Sys Currency.

 

Hope this helps,

 

Rob

Message 6 of 6