Hi
I have two tables, one with sites (2000+) and one with various Planning Allocations each with a Field specifying which it shows. The sites and allocation areas do overlap each other
I need to find the percentage of each site covered by each allocation, 0 is unnecessary as an output
It is expected that the percentage will exceed 100% in some cases (where a site is allocated twice)
Any help with this would be great
Thanks in advance
Adrian