Here's an old-school way of doing it. We haven't upgraded yet, but you might try it.
TOP 001 S 002 0 003 \ 004 005 006 007 008 A;"1" 009 R 010 0 On Wednesday, December 22, 2021 at 2:25:06 PM UTC-5 dfleetham_HMA wrote: > Hi All, > > We've recently (ish) moved from to 5.8.2 from I have no idea what (4.#?). > > In the previous iteration I had a dictionary item that I added to most > files and it was labelled 'CNT'. It was a fixed value of 1 and looked like: > > CNT > 001 I > 002 1 > 003 MR0, > 004 CNT > 005 8R > > And it was useful for counting records in a report; if I ran a query like: > > SORT D:\D_Shared\This Client\ThatCampaign\CUST_GIFT_DATA BY 28 BREAK-ON 28 > TOTAL 22 TOTAL CNT (ID > > I would get something like: > > Last Gift. Gift Amt CNT..... > Year > > 2014 $75.00 3 > 2015 $85.00 4 > 2016 $95.00 4 > 2017 $65.00 2 > 2018 $80.00 3 > 2019 $90.00 3 > ======== ======== > *** $490.00 19 > > Having moved to 5.8.2, the CNT dictionary item doesn't seem to work and > running the same query, I get: > > Last Gift. Gift Amt CNT..... > Year > > 2014 $75.00 0 > 2015 $85.00 0 > 2016 $95.00 0 > 2017 $65.00 0 > 2018 $80.00 0 > 2019 $90.00 0 > ======== ======== > *** $490.00 0 > > There's probably a very simple solution; I just haven't found it. Is there > a better structure for a dictionary item like this? Is there a better > solution I could be using? > > Any help is much appreciated. > > Thanks, > > Doug. > -- -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/1f7f1459-5814-4607-9ebd-58adf62d8075n%40googlegroups.com.
