GetSelectedCount

=’Report Period: ‘ &
if(GetSelectedCount(Year)>=0 and ([Month Name])=0 and max(Year)=Year(today()),’YTD ‘ & max(Year),
if(GetSelectedCount(Year)=0,
if(GetSelectedCount([Month Name])=0, max(Year),
if(GetSelectedCount([Month Name])=1, date(max(Month),’MMM-YY’),
if(GetSelectedCount([Month Name])>=2,left(monthname(min(Month)),3) & ‘ – ‘ & LEFT(monthname(max(Month)),3) & ‘ ‘& max(Year)))),
if(GetSelectedCount(Year)>1, min(Year) & ‘ – ‘ & max(Year),
if(GetSelectedCount(Year)=1,
if(GetSelectedCount([Month Name])=0, Year,
if(GetSelectedCount([Month Name])=1, date(Month,’MMM-YY’),
if(GetSelectedCount([Month Name])>=2,LEFT(monthname(min(Month)),3) & ‘ – ‘ & LEFT(monthname(max(Month)),3) & ‘ ‘&Year,
//if(GetFieldSelections(Year)=year(Today(),’YTD’&year(Today()

)))))))
//))

capture

Advertisements