SET ANALYSIS

[adiarnon]

HI,

I need to creat this expression-

=Sum({<YearMonth={$(=Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))}COMPONENTVALUE)

This expression work good

but i need not when YearMonth = Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))

i need that YearMonth > Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))

how should i do it?

adi

[ecolomer]

See this:

Dates in Set Analysis

[Anonymous]

=Sum({<YearMonth={">$(=Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))"} >} COMPONENTVALUE)

[sunny_talwar]

May be this:

=Sum({<YearMonth={$(='>' & Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))}>} COMPONENTVALUE)

[sunny_talwar]

Alternatively, why not just this?

=Sum({<YearMonth={$(='>' & Date(AddYears(Max(YearMonth), -1), 'YYYYMM'))}>} COMPONENTVALUE)