
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 28, 2024 03:46 PM
Hi - I am trying to do a daily balance and bills owed table and am wanting to match expected income so that the dates match. Ideally it would also have a daily exchange rate.
I am just not sure how to match and roll-up based on varrying criteria without needing a new column for each date.
How do I do this? Do I need a third table?
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 28, 2024 10:40 PM
Hmm, yeah I think you'd need a new table where each record represented a single day:
And you could use automations to link the records appropriately. Not entirely sure I understood your question though, sorry if I got something wrong!
