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;