6 Replies Latest reply: Jun 21, 2013 3:57 PM by Tim Benoit RSS

    turn IF statement into set analysis expression

    Thorsten Schröder

      Hello,

       

      How can I turn this simple if statement used in a chart table

      =if(Currency <> 'EUR', Currency & ' Conversion Table' & '<url>http://www.x-rates.com/d/' & Currency & '/table.html',0)
      

       

      into a statment that won't change no matter what is selected.

      Right now only the selected or possible values have an effect on the table. Which leaves me with some empty url links.

      I'm guessing set analysis is needed for this but I couldn't figure out a syntax to get the job done.

       

      Thank you.