I have a transaction table that looks like this:
0 1 4 5 9
TRANS#...... ACCOUNT#. TR AMT.. TRANS DT SOURCE............
168401X16029 100541 -0.06 02-07-14
168401X15779 100542 -0.07 02-07-14
168401X6246 100545 -0.20 02-07-14
164522X10 100547 16.87 01-11-13 3
164522X11 100547 35.32 01-11-13 3
164513X44 100550 0.77 01-14-13
168401X2867 100554 -0.01 02-07-14
165106X3 100555 250.00 03-11-13 3
165466X5 100555 250.00 04-15-13 3
168401X14627 100555 -0.01 02-07-14
I want to put together a dictionary item that will, for each account number
(attribute 1) sum every transaction amount (attribute 4) from the same date
(attribute 5) where the source (attribute 9) has a value of "3".
I have been banging my head against this and I don't think it is possible.
Am I wrong?
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google Groups
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
