Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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