Creating 3 fields that rely on each other

[MP36]

Hi folks,

I'm trying to create the fields attached in Designer. Changes in Shares is an existing field, and Treasury Shares is just an IF ID=1 then 1,234,567 else Changes in Shares + Row-1 Treasury Shares. The rest of the fields are dependent on another field already existing.

Can someone help me figure out what order I need to create the additional fields in, or suggest a tool that will allow for this sort of interdependency?

Thanks!

[Amarendra]

Sounds like you can use the Multi-row formula tool. Did you try using that?

[MP36]

@Amarendra I've tried using multi-row, but I can't seem to get the formulas into any rational sequential order. I think I would have to reference columns that don't exist yet.

[Amarendra]

Gotcha! Do you mind uploading a file with before and after and I'll give it a shot!

[MP36]

Thank you! Attached below. This is my first post, so let me know if that file doesn't give you enough to take a stab at it. Thanks again!

[Amarendra]

@MP36 PFA, does this work? I appended the change in stock to the dataset since the previously attached file did not have it 

[MP36]

Sorry Amarendra, my original file wasn't clear enough. Change in stock is a function of QTY Exercised Distributed * Treasury Price. I've updated the file to be formula driven in the After tab so you can better follow the fact pattern. Apologies.

[Amarendra]

 @MP36 Updated the workflow, In this case, you will need to append the treasuring pricing as a separate file (since pricing can change with time) so you can reference that and create new fields.