Two similar, but slightly different, methods. My assumption here (based on your post) is that there are two lists (Products and Adjustments) and two modules. In the below solution Adjustments has a top level item called "Totals" (just makes the summary exist, and means we don't have to do any other aggregations later). Module 1 - dimensionality = Products, Time, Adjustments Line Items - "Adjustment Value" (input) Module 2 - dimensionality = Products, Time Line Items - Negative Adjustment Value, Positive Adjustment Value, Net Adjustment Option 1: Might seem obvious, but create two new line items against Module 1 - "Negative Adjustment Value" and "Positive Adjustment Value", which returns the appropriate adjustment value. Negative Adjustment Value = MIN(0, Adjustment Value) Positive Adjustment Value = MAX(0, Adjustment Value) In Module 2: Negative Adjustment Value = 'Module 1'.Negative Adjustment Value Positive Adjustment Value = 'Module 1'.Positive Adjustment Value In this solution, we're summing all entries regardless, but have modified the values such to return 0 if not of the appropriate type (negative/positive respectively). Option 2: Similar, but slightly different option. Two new line items called "Negative Adjustment Helper" and "Positive Adjustment Helper" in Module 1 - format as "Products". Negative Adjustment Helper = IF Adjustment value < 0 THEN ITEM(Products) ELSE BLANK Positive Adjustment Helper = IF Adjustment Value > 0 THEN ITEM(Products) ELSE BLANK In Module 2 Negative Adjustment Value = 'Module 1'.Adjustment Value[SUM: Negative Adjustment Helper] Positive Adjustment Value = 'Module 1'.Adjustment Value[SUM: Positive Adjustment Helper] In this solution however, we're only aggregating the values that are relevant - we limit this by creating those aggregation helpers ("XX Adjustment Helper"). Let me know if you need further explanation on either of these 😊
... View more