Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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.
@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.
@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.
