Sort of a hybrid situation. If they are all single valued, then it should be straight forward. Your example may not be exposing the nuances that are causing your problems.
If it is all single valued, then I would try in <8> A;IF 9 = "3" THEN 4 ELSE "0" The rest of it is in the sort list sentence to break-on 5 with a det-supp. i.e. sort file by 1 by 5 break-on 1 break-on 5 total <new dict item> id-supp det-supp From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Saturday, March 08, 2014 11:24 PM To: [email protected] Subject: Summing transactions - JBASE 5.1 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. _____ No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4335 / Virus Database: 3722/7169 - Release Date: 03/08/14 -- -- 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.
