I want sales wrt finicial year only for which quater has ended.Example
For year 2012-13 my three quater is completed i.e q1,q2,q3 so my sales should come but for q4 only two mnths is compeletd so no data should come for q4 of 2012-13.
Please help me out...
I propose to move the relevant data to a new table by using QuarterStart and QuarterEnd in a where-clause:
Date as MaxLastQ_Date,
Sale as MaxLastQ_Sale
(biff, embedded labels, table is Sheet1$)
WHERE QuarterEnd(Date) < QuarterStart(Today());
I'll would look for which quarter tomorrows date fall under and then exclude it.
Example1: My last transaction data is from 2012-12-31 (q4 2012), the day after is 2013-01-01 (q1 2013). I will only include Quarters < q1 2013
Example2: My last transaction data is from 2012-12-15 (q4 2012), the day after is 2013-12-16 (q4 2012). I will only include Quarters < q4 2012.
Then I would have implemented a calendar with a Quarter index of some kind.
try this code
(biff, embedded labels, table is Sheet1$);
Day(date) as day,
Month(date) as month,
Year(date) as year,
yearname(date,0,4) as FinancialYear;
date(Date#(date,'DD.MM.YYYY')) as date,
(biff, embedded labels, table is Sheet1$); .