Incrementing Total not correct(adding +1) in some group totals

[Former Member]

Hi All,

I have an incrementing total that appears to work fine except when I try to display the total's final count only SOME groups have a +1 count. There doesn't seem to be a logical reason for it.

Any ideas?

Incrementing total formula:

Whileprintingrecords;

if Not({Command.BI_UPD_DT_TM} > {@f_ConvertRevYrMo_DtTm})

then
Global numbervar memberlinecnt := memberlinecnt +1
else

memberlinecnt+0;

Formula to call incrementing total's final group total:

Global numbervar memberlinecnt:={@f_RRTMemberIncrement};
memberlinecnt;

Note: I've not been able to use Running Total fields with this report because I need to evaluate totals based on group criteria and there are multiple groups and criteria.

[Former Member]

believe you need a reset on the group

[Former Member]

Hi Sharon,

I do have a reset, just didn't include it in my post.

Reset

//@Reset (Place this in the group header section suppressed) 
WhilePrintingRecords; 
Global NumberVar memberlinecnt:= 0; 

Like I said,the whole thing appears to work, counting for ever group, resetting; except for only some groups, the total is +1 of the total. I don't know why.

Thanks,

John

[Former Member]

check to see if you have repeat group header on the groups that throws off the totals

[Former Member]

Thanks Sharon,

That wasn't it, but it did make me think to move my Reset counter up a level in the groups... and that corrected this counting issue.

Yay,

J