6 Replies Latest reply: Feb 2, 2011 4:17 PM by RickInNC RSS

    Set Analysis Question

      I have the following in a text box:


      =Only([Fiscal Quarter])

      This displays:

      Second Quarter

      In a chart I have:



      ( {1
      //< [Fiscal Year] = {$(=Only([Fiscal Year]))}, [Fiscal Quarter] = {'Second Quarter'} >
      [Fiscal Year] = {$(=Only([Fiscal Year]))}, [Fiscal Quarter] = {$(=Only([Fiscal Quarter]))}>
      Pounds )

      If I comment the attempt to use the value selected and use the literal I get results, if I try to use the selected quarter, I get no results.

      Your help is appriated,