Set Analysis help??

[rohitians]

Dear all,

I have two codes need help for set analysis,

I have two codes like three months in a row as for now May-14 Apr-14 March-14

For Apr-14 i have wrote

AVG({$<FinancialYear=,MonthName=,FiscalYear = {$(=max(FiscalYear) - $(=if(max(MonthNumber) = 1, 1, 0)))}

,PostingDate={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate),-1))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate),-1))"},Location_Name_Short={'MFG-GOA I'}>}

Purchaseline_UnitCost)

For May-14 i wrote,

AVG({$<FinancialYear=,MonthName=,Quarter=,FiscalYear={$(=max(FiscalYear))}

,PostingDate={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate)))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate))"},Location_Name_Short={'MFG-GOA I'}>}

Purchaseline_UnitCost)

Kindly help me to write code for Mar-14 on same lines

Thanks and Regards,

Rohit

[rohitians · Accepted solution]

I got the solution i simply used,

AVG({$<FinancialYear=,MonthName=,FiscalYear = {$(=max(FiscalYear) - $(=if(max(MonthNumber) = 1, 1, 0)))}

,PostingDate={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate),-2))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate),-2))"},Location_Name_Short={'MFG-GOA I'}>}

Purchaseline_UnitCost)