Let say I have a table like this
SalesDate SaleAmount
10/02/2010 55
11/03/2009 44
5/05/2011 33
2/04/2011 11
1/07/2011 3
5/11/2012 6
2/02/2012 18
1/01/2012 24
3/04/2012 10
1) How can I show total SalesAmount if SalesDate is less then 12 months old from todays date. In this case expression will read each record and add total sales if the date is not older then 12 months.
I want to show this is a text box.
The below expression does not work because it cannot read each salesdate individually and total it.
if(SalesDate > AddMonths(today(),-12),sum(SalesAmount),0)
please help
thanks
