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() ))))))) //)) Advertisements Continue reading GetSelectedCount