Skip to main content

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