Skip to Content
0
Former Member
Jun 08, 2011 at 04:33 PM

Help with Counting Formula that ignores duplicate rows; count first row

24 Views

Hi Everyone,

I have a supression formula to hide duplicate rows in my report:

({BI_SO_MASTER.BI_SO_NBR}=previous({BI_SO_MASTER.BI_SO_NBR}))

I also have a counting formula that counts each row. To ignore the supressed rows, I've added the above formula to it.

It works great except it isn't counting the first row. Any ideas how to include the first row in the count??

Counting Formula that ignores duplicate rows:

Whileprintingrecords;

if 
if NOT ({BI_SO_MASTER.BI_SO_NBR}=previous({BI_SO_MASTER.BI_SO_NBR}))
then
Global numbervar memberlinecnt := memberlinecnt +1
else
memberlinecnt+0;