Use VBA to add "Total" to BOM column

I need to add a row to each of my BOM's showing a total weight (eventually they will all be combined into one overall total, but I haven't found a way to do that parametrically yet...).  I can add the row, and format it the way I want it.  My problem is getting the TOTAL formula to work.  I tried using iTableAnnotation:Text, but it just adds the string value, and doesn't evaluate anything.  The macro recorder wasn't any help either.  Any ideas on how to get an equation to work in a BOM cell?

SolidworksApi macros