Build a formula into an xlsx output file to sum rows

Question

Hello,

I have built flow to group then sum data by customer and order number, the output shows a static totals line per charge type. I need the totals line on the output to be an active formula (sum) so that when the output user makes amendments to the data on the output file, the totals line will adjust the total accordingly. Is it possible to output a formula?

Building the totals line.JPG

Output lines requiring active formula.JPG

Anon Data.xlsx

Formula In Outputs.yxmd

apathetichell · Answer

Search out how to use an excel file template and to copy/output to that template via blob input/output and then output data to write in a range. That is how you get what you want. There are  numerous community posts on it - but it's not incredibly straight forward/easy. It will take some trial and error. The key parts are the your formulas must be on your template. You must have the template in a specific location. you must have a name for the copy of your template you are creating. you must append that name to your datastream and output your data to the file AFTER you create the copy with your blob output tool.

SnapperFlower · Answer

Thank you for your response and link to another discussion, I will take a look at that. The purpose of the flow is to output a proforma invoice which reconciled, adjusted and agreed upon by 2 parties before issuing a sales invoice, hence requiring a formula in the totals

Yoshiro_Fujimori · Answer

Hi @SnapperFlower ,

In general, consdering the data integrity, I would not allow the user to make amendments to the data.

Having said that, the discussion below may help.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Excel-Formula-Output/td-p/459646