Hi all,
Is there a tutorial or examples of set anaylsis flying around? I need to be able to use today's date to calculate the accounting period that we are in and then using that answer, calculate how much sales we have using the answer as a filter.
i.e Today is July 2nd, The accounting period that it is in is July (There is an accounting period table with dates and the date 02/07/2009 has the Period July). and I have to sum up the values in that period.
I have 2 tables
Acc Period
Date Period
26/06/2009 June
27/06/2009 June
28/06/2009 July
..
..
24/07/2009 July
25/07/2009 August
Sales
Date Value
27/06/2009 100
28/06/2009 200
24/07/2009 150
25/07/2009 100
From the example there, I would expect my sum to equal 350.
Could you please help?
Thanks,
Mike
