balancing cells on criteria
Hello,
I have the following data:
ACC_DAT DIM1 DIM2 DIM3 DIM5 DIM7 JR_NR MONTH REC_AMOUNT BALANCE
010507 9990 15 2000 150 AR30-390 19556 05 90.00
010507 9990 15 2000 190 AR30-390 53339 05 -30.00
010507 9990 15 2000 190 AR30-390 53397 05 -40.00
010507 9990 16 6000 100 AR30-390 53541 05 -10.00
010507 9990 16 6000 190 AR30-395 54072 05 0.01
010507 9990 16 6000 100 AR30-396 56578 05 -50.00
010507 9990 16 6000 190 AR30-396 57076 05 -10.01
010507 9990 16 6000 190 AR30-396 57185 05 60.01
I need a function in column BALANCE that looks if the REC_AMOUNT BALANCES
BASED ON DIM7 OR DIM5 OR JR_NR.
Thanks,
|