Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
Hi,
You can try like this
num(sum( {$<[Year of date]={">=$(=Max([Year of date])-1)<=$(=Max([Year of date]))"}>} RVN_AIRTIME),'# ##0')
no it didn't work, i would like that the dates of year 2016 would be until today 12/10 without displaying the year
Perhaps this?
num(sum( {$<[Year of date]={'$('<=' & =Today())'}, Year = {'$(=AddYears(Max(Year),-1))'}>} RVN_AIRTIME),'# ##0')
Do you have any date field.