Last year to date

[#1]

Hi wizards,

i need your advice.

I have this part of expression:

sum({<Year_financial={$(=max(Year)-1)},Date=.....?????>}(Sale))

Now i want - Calculate sales for last financial year, but only till actual date (i mean today is 15.8.2013, so calculate sales of last financial year till 15.8.2012 - financial year is from april till may, so give me sales from 1.4.2012 to 15.8.2012)

I hope it´s easy for you 😉

Thx a lot

Jaromir

[swuehl]

Maybe

Date={"<=$(=AddYears(Today(),-1))"}

[#3]

Hi, Maybe try this

Sum({<YourDate = {'$(=Date(Today()))', '$(=Date(AddYears(Today(), -1)))'} >} SalesAmount)

All the best

[erjohnso]

Probably not the best solution for days but I created a bookmark "YTD" for my monthly YTD comparisons across several years.