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

[#1]

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

[kaushiknsolanki · Accepted solution]

Hi,

     If you want user to see only year to date result even if they select the date and month and week then you must exclude those selection as shown in below expression.

     sum( {$<Year = {$(#=Only(Year))},Month=,Week=,Day=,Date=>} CURSALES )

Regards,

Kaushik Solanki

[#3]

Thank Kaushik.

You are a Star!