2 Replies Latest reply: May 1, 2013 8:59 AM by michael lock RSS

    Year to date based on Current Month/week/day Selection

      Hi All,


      Im trying to find a method of showing Year To date against other figures.


      My users will be selecting a a minumum of the Year but may also select other criteria , such as Day, Month , Week, Quarter.


      I need to show a sum for the selection but i want to show a Year to date figure based solely on the Year Selection and disregard the other slections


      I have tried tweaking this standard expression (below)but i appear to be missing something


      sum( {$<Year = {$(#=Only(Year))}>} CURSALES )



      Thank you