Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to show results from the previous completed month minus 1 year back. So I would like to get data from 05/2011 - 05/2012. Below is my expression, but it only returns the current months data, so 06/2011-06/2012. Any hep would be apprecaited.
SUM
({<CAL_CENSUS_DT.Date={"<= $(=MAX(CAL_CENSUS_DT.Date)) >=$(=ADDMONTHS(MAX(CAL_CENSUS_DT.Date),-12))"},PT_CLASS={1,114}>}PT_DAY_COUNT
)
SUM
({<CAL_CENSUS_DT.Date={"<= $(=addmonths(MAX(CAL_CENSUS_DT.Date),-1)) >=$(=ADDMONTHS(MAX(CAL_CENSUS_DT.Date),-13))"},PT_CLASS={1,114}>}PT_DAY_COUNT
)