SUM of CASE in Beast Mode

Hi,

I am trying to sum a column based on date value output from another case statement, but i dont see anything getting calculated when i check the formula.

there are no formula validation issues.

SUM((CASE when (CASE when DATE_FORMAT(`Date`,'%d')=1
 	then 
	(CASE when DATE_FORMAT(`Date`,'%m')=1 
		then 'Open Month' else 
			(CASE when DATE_FORMAT(`Date`,'%m')=4
    				then 'Open Month' else
    					(CASE when DATE_FORMAT(`Date`,'%m')=7
        					then 'Open Month' else
        						(CASE when DATE_FORMAT(`Date`,'%m')=10
            						then 'Open Month' else '' end)
					end)
			end)
	end)
	else
 	(CASE when LAST_DAY(`Date`)=`Date` 
    	then 
    	(CASE when DATE_FORMAT(`Date`,'%m')=6
                    	then 'Close Month' else
                    	(CASE when DATE_FORMAT(`Date`,'%m')=9
                        	then 'Close Month' else
                        	(CASE when DATE_FORMAT(`Date`,'%m')=12
                            	then 'Close Month' else '' end)
                         end)
         end)
     else
     (CASE when CURRENT_DATE()=`Date` 
     	then 'Close Month' else '' end)
     end)
end)='Open Month' then `Total_HC_Opening` end))