I have a subject area table containing records with columns account no., txn code and amount e.g. A/C No. Txn Code Amount A01000 T1000 $5000.00 A01000 T2000 $3000.00 A01100 T1000 $8888.00 A01100 T2000 $4444.00 I want to get a result of Net amount by A/C No. e.g. Net Amount for account A01000 = $5000 (T1000) - $3000 (T2000) = $2000 How can I do this in an analysis?
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!