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 

       

      Michael