Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I Have two Charts A & Chart B
Two input Boxes FromDate & ToDate
Chart A : Dynamically Generated columns for current selection of FromDate & ToDate
=if( Date >= vFromDate and Date <= vToDate,Month(Date)&' - ' &right(Year(Date),2))
my requirement is to have
Chart B: which should Generate columns for previous year for same FromDate & ToDate selection
i tried this expression but doesnt work.
=if( Date >=date(num(MakeDate(year(vFromDate)-1,Month(vFromDate),Day(vFromDate)))) and Date <=date(num(MakeDate(year(vToDate)-1,Month(vToDate),Day(vToDate)))),Month(Date)&' - ' &right(year(vFromDate),2))
pls help!!
try with this
=if( Date >= addyears(vFromDate,-1),
and
Date <= addyears(vToDate,-1) , TEXT(Date(Date, 'MM-YY'))
=if( Date >= addyears(vFromDate,-1) And Date <= addyears(vToDate,-1) , TEXT(Date(Date, 'MM-YY')))
DOESNT WORK
what is the date format of your variables ?
sorry ramon,
It did work finally had some conflict with hidden dates . so cleared them