Enform count()

[Mester Pandele]

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

[JShepherd]

Post by Mester Pandele
Hello,
Does anybody know how can I count 'val' values over by-item with Enform

count fu

Post by Mester Pandele
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

Post by Mester Pandele
list by i16u as i12
count (i16u over i16u);

COUNT
I16U I16U
------------ --------------

43140 1
57344 2