Creating 3 fields that rely on each other
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sounds like you can use the Multi-row formula tool. Did you try using that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Gotcha! Do you mind uploading a file with before and after and I'll give it a shot!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MP36 PFA, does this work? I appended the change in stock to the dataset since the previously attached file did not have it
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
![](/skins/images/D34B41DA407DC996E7BFF253AD24F7E2/responsive_peak/images/icon_anonymous_message.png)