2 Replies Latest reply: Nov 22, 2013 10:03 AM by Evelien Morel RSS

    Variable as expression

    Evelien Morel

      Hi all,

       

      I'm trying to use a variable as an expression.

      It works but only half. Can anybody shed some light please?

       

      I have a inputbox with predefined values only, being 'EUR' and 'Local'.

      Whatever is selected in the inputbox, goes to a variable vCurrency.


      I use the variable in another variable vCurrAmount.

      In that variable I define the following:

      if(vCurrency = 'EUR', [Amount EUR Curr], [Amount Transaction Curr])

       

      In my chart, I use the variable vCurrAmount as expression.

      sum($(vCurrAmount))

       

      This works fine if in the inputbox the option 'EUR' is selected.

      If I select the option 'Local', the expression doesn't work anymore.

       

      I've tried a lot of different thing with $ signs and = marks.

      Nothing seems to give me the correct result.

       

       

      Many thanks in advance.

      Evelien