Annual Trend Report - multiple parameters

[onebigscot]

Hello,

I am working on an annual payroll trend report - comparing monthly budgets numbers against the actuals as they are produced. There will be 24 columns of information: 12 with budgets which are predetermined and twelve that will develop with each month.

Is there a way I can set the parameters for each actual column so I can run it to show 7/1 - 7-31; 8/1 - 8/31; 9/1 - 9/30 etc?

I am pulling the figures out of MAS200 General Ledger.

Thanks!

 

[synapsevampire]

I'd create the 24 columns based on an initial date parameter value for StartDate, and calculate the other dates in the evaluate->Use a Formula using Running Totals (or you could use regular formulas and manually sum):

#Month1
{table.Date} >= {?StartDate}
and
{table.Date} <= dateadd(&quot;m&quot;,1,{?StartDate})-1

#Month2
{table.Date} >= dateadd(&quot;m&quot;,1,{?StartDate})
and
{table.Date} <= dateadd(&quot;m&quot;,2,{?StartDate})-1

Note that each month would increment by a month based on what you entered in the parameter. Or you could substitute

cdate(year(currentdate),month(currentdate),1)

To base it on the current month.

-k

 

[onebigscot]

I'll give it a shot. Thank you!