YTD for fiscal previous year

[ferha_jafri]

Hello Everyone,

I have issue with YTD fiscal year which starts from jul to june the issue is that when i writing YTD expression the dates are showing fine but when i am checking for it for previous year the values are not mathich.

[sujeetsingh]

Can you post a sample !!

[vikasmahajan · Accepted solution]

Hii Ferha,

try following expression

SUM({$<FiscalYear={$(=max(FiscalYear)-1)},YEAR_MONTH=p(YEAR_MONTH_PREVIOUS),[Posting Date]={'<=$(vLMaxDate)'},FinancialYear=,MonthName= >}  [Sales Amount])

1.  YEAR_MONTH_PREVIOUS  is filed to create in calender master is as follows

     num((Year(TempDate)-1)&num(Month(TempDate),'00')) AS YEAR_MONTH_PREVIOUS, // Link between tables for                            previous month / year selection

2. vLmaxdate  is variable

=date(addyears(max([Posting Date]), -1), 'DD/MM/YYYY')

Hope this helps you for previous year ytd  vs curr year ytd  ( Like wise comparison)

Vikas

[ferha_jafri]

thanks for everyone's reply.