Handling Excel Output Summation with Formulae Embedded
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
In my application, I need my output written to Excel, and since there is subsequent manual input (lines 2 and 9), I'm trying to include a summation formula on row 10, as shown in both Columns D & E:
My problem is regardless of whether I use an Output Data tool, or Basic Table + Render tool, the numeric values that you see above are not considered numeric in Excel. That is, the summation formula always gives 0.
I would expect 15,996 in D10, and 53,484,665 in E10 above.
As an aside, I had seen the "FORMULACORRECTOR" approach (D10) used elsewhere, which does require the extra step of a manual search & replace in Excel afterwards to remove it, and I'm not sure why that was used in the first place.
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Peachyco One other question: I'm not too familiar with these tools yet, but do you know if it's possible to use the Table, Layout, and Render (to Excel) tools, to allow the sub-table outlined in red to appear beneath that outlined in green? My thinking is to attempt to keep B2:C6 as numeric data types, and then drop the red sub-table beneath it. This is a stretch, but worth asking.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Peachyco I'm not that familiar with these tools yet, but do you think there might be an opportunity to use the Table, Layout, and Render (to Excel) tools here?
In this example:
My thought is to have one sub-table (as outlined in green), and then a second sub-table (in red) "shifted" beneath the first one. The idea here is to try to preserve cells B2:C6 as numeric data types so that the formulae work properly. It's a stretch, but worth asking the question. Thanks.

- « Previous
-
- 1
- 2
- Next »