Yes, I'm afraid I'm back.. I just can't get this to work out.. I've attached a screen print this time of my report along with a PDF of what the report looks like thus far.

In the GROUP FOOTER 3, under the YTD column (row LY for last year), I am trying to get a sum of the Months that are <= current month but in the previous fiscal year which run from 10/1 to 9/30..

So at this moment I'd only want to see a sum that would run from 10/1 through current for the previous year.

Then I would want this to continue automatically going forward without the user needing to put in any dates. I am just not advanced enough to pull this one off. I've tried everything I can think of.. Including a formula someone shared with me on an earlier post.

zmyh-rep-cust-edp-fiscal-ytd.pdf
screen.gif
you will have to modify the date ranges, but here is what I do for my company's fiscal reporting.

local numbervar x;

local numbervar y:= month(currentdate);

if y = 1 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 2 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 3 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 4 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 5 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 6 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 7 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 8 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 9 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 10 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 11 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

if y = 12 and y in dateserial(year(currentdat

then x:=(({oelinhst_sql.qty_to_

x