value 2016 until today

[master_student]

Hello Guys,

How to change this expression bellow so it gives me the value of year -1 until today 20/10

My calendar dimension contains : Calendar Date with that format : 20/10/2017

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

Thanks in advance

[sunny_talwar]

Is Year of Date a year field or date field?

[master_student]

Year field

[Anil_Babu_Samineni]

This?

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

[sunny_talwar]

May be this

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

[sunny_talwar]

I am assuming that you won't have future data in your app... if you do, then you will need to use date instead of year field

[master_student]

Hello Sunny,

Thanks

whene I use your expression i get this error:

Error: Error in set modifier ad hoc element list:

',' or ')' expected

the year field like this

[master_student]

your expression give me the total of 2016 and 2017 until today, I need the total of 2016 until 20/10/2016

[sunny_talwar]

Try this

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

[master_student]

Thanks Sunny, same thing as Anil, your expression give me the total of 2016 and 2017 until today, I need the total of 2016 until 20/10/2016