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:

       






      Sum

      ( {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,

      Rick