Last year data not showing

[prma7799]

Dear All,

I am able to see last year data.

PFA...

[sunny_talwar]

May be this:

Sum({<Year=, MonthName=, Quarter=, Flag = {'Values'}  , Date={">=$(=Date(YearStart(Max(Date), -1), 'MMM-YY'))<=$(=Date(AddYears(Max(Date), -1), 'MMM-YY'))"}>} Amount)/10000000

[prma7799]

Hi Sunny,

After selection there is not showing any data for LY

[agomes1971]

Hi,

expression for only the last year:

Sum({< Flag = {'Values'}, Year={"$(=max({1} Year))"} >} Amount)/10000000

HTH

André Gomes

[sunny_talwar]

Try this:

Sum({<Year=, MonthName=, Quarter=, FiscalYear =, FinancialYear =, Flag = {'Values'}  , Date={">=$(=Date(YearStart(Max(Date), -1), 'MMM-YY'))<=$(=Date(AddYears(Max(Date), -1), 'MMM-YY'))"}>} Amount)/10000000

[prma7799]

Sunny data is not coming right ....

Please check....

if i check...

[sunny_talwar · Accepted solution]

How about this:

Sum({<Year=, MonthName=, Quarter=, FiscalYear =, FinancialYear, Flag = {'Values'}  , Date={"$(='>=' & Date(YearStart(Max(Date), -1, 4), 'MMM-YY') & '<=' & Date(AddYears(Max(Date), -1), 'MMM-YY'))"}>} Amount)/10000000

[agomes1971]

Hi,

if you based on year selections

Hi,

expression for only the last year:

Sum({< Flag = {'Values'}, Year={"$(=max({$} Year))"} >} Amount)/10000000

HTH

André Gomes

[Anonymous]

have a look to that Expression:

=Sum({<FinancialYear=,FiscalYear=,Year=, MonthName=, Quarter=, Flag = {'Values'} ,Date={">=$(=date(addyears(Min(Date),-1),'MMM-YY'))<=$(=date(addyears(Max(Date),-1),'MMM-YY'))"}>} Amount)/10000000

[prma7799]

Sunny this expression takes data only for few months ...

Can you please give me simply expression for YTD MTD  LYTD LMTD...