Okay, I found the solution via variables. This is what I did...
Formulas #1 and #2 placed in Details Section and suppressed...
Formula #1:
IF {table.activated}=True and table.id<>"" then 1;
Formula #2:
whileprintingrecords;
global numbervar activatesum;
activatesum :=activatesum + (name of Formula #1);
Formula #3 placed in Report Footer Section...
Formula #3:
whileprintingrecords;
global numbervar activatesum;
Thank you for all your help and patience.
Merry Christmas and Happy New Year!