Hoping there is maybe native support here now, but probably not.
I have a table where all the records are parts, and they have part ID, unit weight, quantity, and total weight. I would like to add a field that shows what % of the total weight of ALL parts that particular part is. So for example if my total weights of 4 records are 100, 200, 300, 400, then for records 1-4 the % in the calc'd value would be 10% (100/(100+200+300+400)), 20%, 30%, and 40%.
I know this was limited in the past and the "best" workaround was to link every single record to a single record in another field, then lookup the roll-up sum total, then operate on that. It works but is clunky and gives you extra tables. Is there anything native baked in yet? Seems airtable has made a lot of progress but it still has these weird "create a new table and link to that and then roll-up there and then look-up in the original table and then operate on that" work-arounds that should have been long-since handled to simply base design. Does this one exist yet? Can you SUM a whole field (beyond the "SUM" at the bottom of the page or at group roll-ups, obviously if they have this then they have a mechanism or data point that could be called for a formula).
