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]

Do you have a date field in your application?

[Anil_Babu_Samineni]

What are you getting when you use this? Year(AddYears(Date(Today()),-1))

[mostwanted123]

Try this,

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

Regards,

Pratik Bhor

[sunny_talwar]

But Anil how can you compare date to an year field brother?

[Anil_Babu_Samineni]

We can't with out Date field Bro

[sunny_talwar]

and that is exactly what I asked above

[mostwanted123]

Sorry for the extra bracket,

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

Regards,

Pratik Bhor

[master_student]

yes it's Calendar date

[sunny_talwar]

What is the format of this field? May be try this

Num(Sum({$<[calendar date] = {"$(='>=' & Date(AddYears(Today(), -1), 'DateFieldFormatHere') & '<=' & Date(AddYears(Today(), 0), 'DateFieldFormatHere'))}>} recharge_amount),'# ##0'))

[master_student]

the format is DD/MM/YYYY