We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Build a formula into an xlsx output file to sum rows

SnapperFlower
7 - Meteor

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?

 

 
 

 

3 REPLIES 3
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

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/4596...

 

SnapperFlower
7 - Meteor

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

apathetichell
20 - Arcturus

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.

Labels
Top Solution Authors