Free Trial

Alteryx Designer Desktop Discussions

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

record excel formulas in the output

OJet
7 - Meteor

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

RecordHelperPercentValueneeded formula
2 100%100.00=100
3290%90.00"=C3*D2"
4280%80.00="C4*D2"
5258%58.00"=C5*D2"
6565%37.70"=C6*D5"
7699%37.32"=C7*D6"

The helper column value will always indicate the row above the current position

 

is this possible?

Thank you!

1 REPLY 1
OJet
7 - Meteor

hi, never mind, i figured it out- it's a multi row formula "="+"C" + ToString([RecordID]) + "*D" + ToString([Helper])

thank you!

Labels
Top Solution Authors