1 Reply Latest reply: Apr 25, 2012 9:40 AM by Steve Dark RSS

YTD View given MTD View

Brandon Breitling

Community,

 

I have an issue.  Is there a way to caculate YTD based on selection of a month and year?  I want the current month and those prior to be selected.  Here is the working set analysis for giving me the selected month and selected year:

 

sum({ $<  balcode={'ACTUAL'},

LinkYear={$(=Only("CurrentDocumentYear"))},

LinkMonth=CurrentDocumentMonth,

              [code]={'RBIACCT'}

             >}PeriodTotal)

 

The CurrentDocumentYear, and CurrentDocumentMonth are the list box selectors.