Hello All,
I have this report which is current year sales vs last year sales...
CY:
(SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},
[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}
>}[Gross Sales Amount])
-
SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},
[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}
>}[Sales Return Amount])
)/100000
LY:
(Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)},
[Posting Date]={">=$(=YearStart(max([Posting Date]),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))"}
>} [Gross Sales Amount])
-Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)},
[Posting Date]={">=$(=YearStart(max([Posting Date]),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))"}
>} [Sales Return Amount])
)/100000
The Above code works fine until i use quarter and month as dimension ...
when i use financial year as dimension i dnt get the desired result please help...
Thanks and Regards,
Rohit
