Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

group DistinctCount total

Status
Not open for further replies.

incsoft

MIS
Jan 6, 2021
3
TR
How can I get the totals to the groups friends?
soru_ocptw4.jpg
 
Can't see your field names, but assuming you want to sum the distinct counts that you inserted at the group level, create a formula like this:

//{@dcnt} to be placed in the group header section and suppress the formula:
Whileprintingrecords;
Numbervar dcnt;
dcnt := dcnt + distinctcount({table.field},{table.groupfield});

In the report footer, add a formula like this to display the result:

//{@displdcnt}:
Whileprintingrecords;
Numbervar dcnt;

-LB
 
Sheet1.Vardiya sum of Sheet1.İşyeri I want to have the group named
 
I am not following what you mean.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top