Alteryx Designer Desktop Discussions

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

Calculation in a Specific Cell Alteryx

araquecastro
7 - Meteor

Hi People,

 

I'm struggling finding a way to do a calculation using alteryx in a specific cell. The output file extension is .xlsx. I'm attaching the resulting file without the calculation but marking in yellow the specific/unique cell where this needs to be calculated without affecting the rows below of it. The Calculation is SUM(G4:G597)/2. Important to mention that the number of resulting rows can change to a value below or above 597. I want this to be executed directly from Alteryx.

 

Any ideas on how to do it?. Your support is appreciated.

 

 

1 REPLY 1
Raj
16 - Nebula

You can refer this if you are changing in the parent Excel value
(1281) Data Output to Template Excel File in Alteryx Designer - YouTube

else you can create a template and then push the values into it using Blob tool.

Labels