Grand Total ???

[ttechie]

I am trying to get the grand total. I have userid's and there total number for each user which get from a formula name @lines. I would like to get grand total. I tried to uses running total and summary but it only give me userid, lastname, and lastDate. Help please.

userid numbers
1010 total 2002
1012 total 5000
1013 total 2312
------
?????

 

[Turkbear]

Hi,
What is the formula you use to get @lines?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ttechie]

numberVar RowsThisRecord;
numberVar UserTotalRows;
numberVar GrandTotalRows;
stringVar Result := '';
numberVar RowCount := int((len({MEDICAL_REPORT_OBJECT.MRO_TEXT}) / 65));
RowsThisRecord := RowCount;
GrandTotalRows := GrandTotalRows + RowsThisRecord;
UserTotalRows := UserTotalRows + RowsThisRecord;
numberVar i;
for i := 1 to RowCount do
(
Result := Result + mid({MEDICAL_REPORT_OBJECT.MRO_TEXT},(i*65) - 64, 65) + chr(10);
);
"Lines Recorded: " & RowsThisRecord & " " &"Total-:" & " " & GrandTotalRows & chr(13) & Result;