Visokio website     Downloads     Video tutorials     KnowledgeBase  
Switching currencies - Visokio Forums
Switching currencies
  •     kmatrix999 April 19, 2016 11:24AM
    We currently maintain an annual data set for 200 countries with a number of fields set in pounds sterling.

    For the first time, we have been asked to provide the data in different currencies

    Is there a simple and elegant way that I can set this up so that I can use a filter box to switch the views on each tab between a limited number of currencies?
  • 1 Comment
  •     paola April 19, 2016 12:03PM
    That's what the variables are for... You could create a text choice variable "Currency choice", where users could use the radio button to switch between GBP, EUR, USD etc.,
    then add a formula field that will contain a nested IF statement, with calculation for each currency choice. Please see a demo in this forum post:


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership