Hello All,
Can you help with the below member formula to calculated YTD , that member formula returns the ELSE condition only as per the screen shot
IF (@ISMBR("Jan"))
"YearTD"= @SUM("Jan"+"Feb"+"Mar"+"Apr"+"May"+"Jun"+"Jul"+"Aug"+"Sep"+"Oct"+"Nov"+"Dec") ;
ELSEIF (@ISMBR("Feb"))
"YearTD"= @SUM("Feb"+"Mar"+"Apr"+"May"+"Jun"+"Jul"+"Aug"+"Sep"+"Oct"+"Nov"+"Dec") ;
ELSEIF (@ISMBR("Mar"))
"YearTD"= @SUM("Mar"+"Apr"+"May"+"Jun"+"Jul"+"Aug"+"Sep"+"Oct"+"Nov"+"Dec") ;
ELSEIF (@ISMBR("Apr"))
"YearTD"= @SUM("Apr"+"May"+"Jun"+"Jul"+"Aug"+"Sep"+"Oct"+"Nov"+"Dec") ;
ELSEIF (@ISMBR("May"))
"YearTD"= @SUM("May"+"Jun"+"Jul"+"Aug"+"Sep"+"Oct"+"Nov"+"Dec") ;
ELSEIF (@ISMBR("Jun"))
"YearTD"= @SUM("Jun"+"Jul"+"Aug"+"Sep"+"Oct"+"Nov"+"Dec") ;
ELSEIF (@ISMBR("Jul"))
"YearTD"= @SUM("Jul"+"Aug"+"Sep"+"Oct"+"Nov"+"Dec") ;
ELSEIF (@ISMBR("Aug"))
"YearTD"= @SUM("Aug"+"Sep"+"Oct"+"Nov"+"Dec") ;
ELSEIF (@ISMBR("Sep"))
"YearTD"= @SUM("Sep"+"Oct"+"Nov"+"Dec") ;
ELSEIF (@ISMBR("Oct"))
"YearTD"= @SUM("Oct"+"Nov"+"Dec") ;
ELSEIF (@ISMBR("Nov"))
"YearTD"= @SUM("Nov"+"Dec") ;
ELSE
"YearTD"= "YearTotal" ;
Thank You