I'm unable to open the file you uploaded however, i don't think the 'Show column grand totals' works on IF statements.
can you post a screen shot or replicate the result you want with a dummy data set in excel?
Did you just want the % to Goal to Sum as 142.40%?
If so go to Analysis > Totals > Total All Using > SUM
No, sorry I'm looking for the percent to goal in the Grand total to be $2,297,201/$14,500,000 or 15.8%