hi everyone,
i have the following customer names and amounts:
A B
Customer A 99.00
Customer A 15.00
Customer A 45.00
Customer A -100.00
Customer B 5000.00
Customer B -25.00
Customer C 100.00
Customer C 123.00
Customer D 100.00
I want to remove the negative values from this list by subtracting them from the first positive values that appears for each customer until the negative value becomes zero.
If the absolute value of the negative amount is greater than the first positive value for the customer, then continuing subtracting in the next row for the same customer.
Do this for each customer. How can this be done?
Thanks everyone!
i have the following customer names and amounts:
A B
Customer A 99.00
Customer A 15.00
Customer A 45.00
Customer A -100.00
Customer B 5000.00
Customer B -25.00
Customer C 100.00
Customer C 123.00
Customer D 100.00
I want to remove the negative values from this list by subtracting them from the first positive values that appears for each customer until the negative value becomes zero.
If the absolute value of the negative amount is greater than the first positive value for the customer, then continuing subtracting in the next row for the same customer.
Do this for each customer. How can this be done?
Thanks everyone!