I’m going to try to make sense of a wall I’ve been hitting for three days…I appreciate any help!
I’m working on creating a corporate budget to help a co-worker get organized.
Table 1 - Budget Categories (How much has been allocated for each category, how much has been spent, links to what receipts were spent in the category and who has spent in each category)
Table 2 - Receipts (What was spent where, links to staff that spent, and links to what category it is coming from)
Table 3 - Staff (SHOULD BE: How much of the category’s total (ALLOCATED AMOUNT field from Table 1) each person (NAMES field from Table 3) has spent (AMOUNTS field from Table 3) in percentage form displayed on Table 2)
Currently, every table links to every table. I’ve tried formulas (sums and if’s mostly), rollups, and lookups, and I haven’t found anything that works. This doesn’t seem like such an out of the box request that it wouldn’t be possible.
I’m thinking either I’m totally hitting every formula except the right one, OR I need to change some fields around for some reason.
Right now, this is totally a mock budget until I figure it out, so I’m open to a fresh start or fixing what I already have. Any ideas?
I should also probably mention that I’m on a free account for now - so no access to blocks.
Can you post a link to the base? (I’m assuming, if it’s a mock budget, you won’t need to sanitize it too much; if that’s incorrect, feel free to send me the link by PM.)
Post a read-only link to the base, with copying permitted; that way, anyone who wishes to help can dupe a copy of the base and fiddle around to their heart’s content without risk of muddying your data.
My apologies — I bookmarked this but somehow lost it while syncing browsers. I’m taking a look at it now — assuming you’re still looking for assistance…
Edit: Ah, I think I see where you’re going with this. It’s going to take a little time to block this out; I’ll try to get to it later today or tomorrow…
Hi guys! I’m looking for some help :pray:
I don’t know if @Sarah_Comer’s question was same as mine, but the title of the topic seems similar.
I have a PROJECTS table that should rollup, for each Project, the values of the products in an ORDER LIST table. This table holds the QUANTITY of each item to be ordered, and some of these quantities are dependent on some data contained on a separate CIRCUITS table. This is the main table, where all the technical decisions are typed in.
My problem is how to calculate correctly the dependent QUANTITY field.
The instructions on how the QUANTITY field should work is detailed on the shared base, but here is the same information that is there:
Sorry for any English mistakes, not my native language (Brazilian Portuguese)