Hoping to get some help with a method to help me finish up a labor calculation module.
I'm tasked with allocating costs to contractors differently dependent on if there are multiple contractors from the same "Vendor" and "Area". IF multiple contractors from same Vendor in an Area THEN divide Area cost evenly by month ELSE other calculation.
I'm currently using ISFIRSTOCCURRENCE to identify if a contractor with respective Vendor is a duplicate in a specific Area. This works to identify the dupe but then I cannot use the false booleans to choose as a cost allocation as is discounts the first occurrence contractor.
Do you have any ideas of how to go about this? Please let me know if I can clarify any part of the issue. Thanks for your responses!