date dimension

[master_student]

Hello Guys,

I need your help.

I want to add a condition in my expression so that it will displays values of 2016 year until today

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

[devarasu07]

Hi,

You can try like this

num(sum( {$<[Year of date]={">=$(=Max([Year of date])-1)<=$(=Max([Year of date]))"}>}  RVN_AIRTIME),'# ##0')

[master_student]

no it didn't work, i would like that the dates of year 2016 would be until today 12/10 without displaying the year

[Anil_Babu_Samineni]

Perhaps this?

num(sum( {$<[Year of date]={'$('<=' & =Today())'}, Year = {'$(=AddYears(Max(Year),-1))'}>}  RVN_AIRTIME),'# ##0')

[its_anandrjs]

Do you have any date field.