Gross Profit when COGS not available

So I'm hoping this is not a unique problem.  My company only pulls actual COG data every Wednesday due to Oracle limitations.  Therefore, we would use extended shipment cost in place of COGS for dates when the information is not available.  HIstorically, this meant you would only get margin information after COGS is updated, but we would like to have something that updates daily.  

In the below, I am using a formula to calculate "21 Prf Cost" which is IF(COGS = blank(), Extended Cost, COGS).  I then have a Gross Profit calculation that is 21 Prf Cost/Net Sales. 

The issue as you can see below is that while it works at the line levels, it does not apply to the total properly and therefore skews what should be closer to a 42% margin, making it a 72.89% total.  The highlighted shows that both COGS and the Prf Cost lines are the same, even though the Extended Cost figures are carried over to Prf Cost properly.    

How do I get BI to not only replace the value of COGS with Extend Cost, but also add it to the totals to do the proper calculation?  Thanks in advance, this community is awesome!!