hi Alteryx community,
I am reading A-C to Alteryx from the attached file and i need Alteryx to generate the output of excel formulas in column D -"Value" (I am listing the formulas themselves in Column E)
the first row with the data after headers (row 2 in excel) is always 100
The formulas are C & value of Record Column for the current row * D (the column itself)*Value of the Helper column
Record | Helper | Percent | Value | needed formula |
2 | 100% | 100.00 | =100 | |
3 | 2 | 90% | 90.00 | "=C3*D2" |
4 | 2 | 80% | 80.00 | ="C4*D2" |
5 | 2 | 58% | 58.00 | "=C5*D2" |
6 | 5 | 65% | 37.70 | "=C6*D5" |
7 | 6 | 99% | 37.32 | "=C7*D6" |
The helper column value will always indicate the row above the current position
is this possible?
Thank you!
hi, never mind, i figured it out- it's a multi row formula "="+"C" + ToString([RecordID]) + "*D" + ToString([Helper])
thank you!