Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a calendar table that's linked to another table with a month, year, and date field. I want to make a graph that shows values for the selected year and the previous year. So there would be a set of bars representing data for 2010 and another set for 2009 if the user selects 2010. I'm having trouble witht he previous year expression. Here's what I have so far:
Sum({$<SaleYear={$(=only(Year - 1))}>} SaleAmount)
Nothing it being displayed for this expression. Year is the year selected on the form.
Thanks!
The syntax looks good, but maybe try a max(). I assume SaleYear and Year are numbers, but that might also be work double checking.
Sum({$<SaleYear={$(=max(Year - 1))}>} SaleAmount)
Regards.
Hi, Maybe this way?
Sum({$<SaleYear={$(=Max(Year) - 1)}>} SaleAmount)
rgds