Alteryx Designer Desktop Discussions

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

Preserve formula in Alteryx

mazeem
6 - Meteoroid

How do you preserve formula when outputting data into excel file? When you click in the cell, I want the formula to show what is being calculated.

1 REPLY 1
DavidP
17 - Castor
17 - Castor

Hi @mazeem 

 

When you write data into a cell in Excel, by definition it overwrites the contents of that cell.

 

However, you can write formulas into cells that reference other cells, as shown in the example below:

 

DavidP_0-1640213663200.png

 

The result in Excel then looks like this:

 

DavidP_2-1640213723807.png

 

Labels