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 |
Thanks @Carlithian
Thanks for your help.
I have another requirement regarding web scraping. I will have to research on that.
Thanks once again.