Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you have a date field in your application?
What are you getting when you use this? Year(AddYears(Date(Today()),-1))
Try this,
num(sum( {$<[Year of date]={">= $(=Yearstart(Addyears(Max([Year of date])),-1)) <=$(=Addyears(Today()),-1)"}>} recharge_amount),'# ##0'))
Regards,
Pratik Bhor
But Anil how can you compare date to an year field brother?
We can't with out Date field Bro
and that is exactly what I asked above
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
yes it's Calendar date
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'))
the format is DD/MM/YYYY