Hello
I have two data sources per customer:
1) sales data, where total per customer per month is positive
Customer | Total sales per month |
| A | 200 |
| B | 300 |
| C | 100 |
2) sales data, where I have sales line items per customer, where data has negative value
| Customer | Sales line items |
| A | -250 |
| B | -100 |
| C | -90 |
| C | -50 |
The rule is: I can add line items to the data no 1 only if the value of added itels is higher than 0 per customer.
So for:
Customer A, I cannot add data from source 2 as the total will be lower than 0
Customer B, I cann add data as total will not be less than 0
Customer C, I can add only the first line item as this will be making the total >0
Is there any way to have thnis logic implemented?
