1. Forum
  2. Usenet
  3. COMP.SYS.TANDEM

  • Enform count()

    From Mester Pandele@21:1/5 to All on Mon Jul 24 00:02:08 2023
    Hello,

    Does anybody know how can I count 'val' values over by-item with Enform count function, but only the distinct values? Like the SQL count(distinct...).

    for ex.

    Val1 - group1
    val1 - group1
    val2 - group1

    Enform count(val over group)=3 although there are only 2 distinct values. Thanks a lot,
    pandele

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From JShepherd@21:1/5 to All on Mon Jul 24 16:36:48 2023
    In article <4c528158-f11b-4592-9a7c-459b037f34efn@googlegroups.com>, nsgardek@gmail.com says...

    Hello,

    Does anybody know how can I count 'val' values over by-item with Enform
    count fu
    nction, but only the distinct values? Like the SQL count(distinct...).

    for ex.

    Val1 - group1
    val1 - group1
    val2 - group1

    Enform count(val over group)=3 although there are only 2 distinct values. >Thanks a lot,
    pandele


    Somthing like this ?


    Record INTREC.
    02 PRIKEY Type Binary 64.
    02 JTS1 Type Binary 64.
    02 JTS2 Type Binary 64.
    02 I32S Type Binary 32.
    02 I32U Type Binary 32 Unsigned.
    02 I16S Type Binary 16.
    02 I16U Type Binary 16 Unsigned.
    End


    list by i16u as i12
    count (i16u over i16u);
    COUNT
    I16U I16U
    ------------ --------------

    43140 1
    57344 2

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)