Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Can you post a sample !!
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
thanks for everyone's reply.