expression

[master_student]

Hello Guys,

This expression give me the value of the selectes month and year

=(num(sum( {$<[Year of date]={$(=Max([Year of date]))}>} recharge_amount),'# ##0')- num(sum( {$<[Year of date]={$(=Max([Year of date])-1)}>} recharge_amount),'# ##0')) / num(sum( {$<[Year of date]={$(=Max([Year of date])-1)}>} recharge_amount),'# ##0') *100

I need the expression that give me the value of the selected year and the month -1( in this case august)

the filed month is [Month of date]

Thank you

[sunny_talwar]

May be like this

Create a new field in the script like this

LOAD [Year of date],

     [Month of date],

     Date(Date#([Month of date] & ' - ' & [Year of date], 'MMMM - YYYY'), 'MMM-YYYY') as MonthYear

     ...

FROM ....;

and then this:

=(Sum({$<[Year of date], [Month of date], MonthYear = {"$(=Date(AddMonths(Max(MonthYear), -1), 'MMM-YYYY'))"}>} recharge_amount) - Sum({$<[Year of date], [Month of date], MonthYear = {"$(=Date(AddMonths(Max(MonthYear), -13), 'MMM-YYYY'))"}>} recharge_amount)) / Sum( {$<[Year of date], [Month of date], MonthYear = {"$(=Date(AddMonths(Max(MonthYear), -13), 'MMM-YYYY'))"}>} recharge_amount) * 100