Hi Tykili, I believe you need a staging module to perform this task. I'm assuming your source module is a list of contractors which have a Vendor and Area assigned. Let me know if it is not the case. 1) First, in the source module create a number-formatted line item called "Count" that is always equal to 1. 2) Second, create a staging module in which you do "#contractors = Count[SUM: Vendor, SUM: Area]" 3) This will give you a module in which you see how many Contractors there are for each Vendor/Area combination. Your final formula would be something like "IF #contractors > 1 THEN divide Area cost evenly ELSE other calculation" Hope it helps.
... View more
