Summarizing only Negative numbers and Positive Numbers in separate Line Items
I am trying to solve a dilemma. I have values for a list property called "adjustments". These values can be positive or negative and there can be more than one in the same time period for the same product. (eg: Apples in December 2020 had one adjustment for -10 and another adjustment for 20. The Net effect of these adjustments is 10, but I am trying to identify the -10 in a line item called Negative Adjustments and the 20 in a separate line item called Positive Adjustments.
The point I am trying to prove with the data is that there may be situations where we are adjusting multiple times within the same time frame and those adjustments are potentially offsetting each other which then makes you question whether the adjustment is necessary in the first place.
Does anyone have a solution that would help me sum only the negative numbers within a list property?
I appreciate any help out there.