Default Excel Formula in the Output

[BobjiK]

Hi

This is the output file. In this, Billing FTM = Val.in.rep.cur + Adjustment + True Up.

The Adjustment & True Up columns are subjected to user interpretation. If the user changes the Adjustment or True Up, it must be reflected under Billing FTM. 

For eg., for the 1st row, if Adjustment is changed to 100 and True Up by another 100, Billing FTM must reflect 5200.34

The problem is that once the Output file is created, Alteryx's job is finished. Even if the user modifies the value in those 2 columns, it will not be reflected under Billing FTM.

My idea is to somehow copy the formula, Val.in.rep.cur + Adjustment + True Up behind every cell. Just like how Excel works. 

Is this possible? Or if there is another method, please let me know

Row	G	H	I	M
1	Val.in rep.cur.	Adjustment	True Up	Billing FTM
2	5000.34	0	0
3	5000.23	0	0
4	1234.55	0	0
5	1266.22	0	0
6	14047.58	0	0
7	11459.48	0	0
8	-6402.01	0	0
9	-2411.94	0	0

[Carlithian]

If you are outputting to excel you can just write the formula into the field. You need to work out what your column letters and row numbers are and add them in.

So in the formula tool you have something like

Billing FTM 

Val.in.rep.cur + Adjustment + True Up

but you want something like 
Billing FTM

"=SUM(A" + [RowID] + ":C" + [RowID] + ")"

[BobjiK]

Thanks @Carlithian 

Would you mind sending a sample WF?

I am new to Alteryx.

[BobjiK]

Hi @Carlithian 

I have updated the table with rows and columns. Would you please explain based on that?