Hi, I am trying to create a new row from an existing row that is effectively 1 point in time divided by the next point in time. my table looks like this FieldA FieldB FieldC T0 PQ1 PQ2 PQ3 .... PQ32 Value Value2 Balance 100 98 97 95 ... 2 what I would like to do is create a new row where FieldA and FieldB are unchanged, FieldC will now be 'Decay' and we start dividing PQ1/T0 PQ2/PQ1 ... FieldA FieldB FieldC T0 PQ1 PQ2 PQ3 .... PQ32 Value Value2 Decay PQ1/T0 PQ2/PQ1 PQ3/PQ2 ... PQ32/PQ31 aka FieldA FieldB FieldC T0 PQ1 PQ2 PQ3 .... PQ32 Value Value2 Decay 98/100 97/98 95/97 ... 2/somethign and the final output would look like FieldA FieldB FieldC T0 PQ1 PQ2 PQ3 .... PQ32 Value Value2 Balance 100 98 97 95 ... 2 Value Value2 Decay . 0.98 0.989795918 0.979381443 something could you please help me figure out how to iterate through this process. Best, Chris w.
... View more
