Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Discard all others

Morning all,

I have created a new report based Workingdays Group.

Here how the report is set up.

I created a group based on the Working Days formula, then I added a formula

Whileprintingrecords;
Numbervar x:=0;
x:=DistinctCount({order_header.order_no},{@WorkingDays});
x;

into that group.

I have four different Running Totals on Page header, one shows total jobs, cancelled jobs, still in lab jobs and credit jobs.

I have preset the date range from date(2008,09,01) to date(2008,09,30) under Report Section Record Formula.

Upon Preview mode, all the days and jobs comes up correctly however right on the top of 1st day it shows the total of Cancelled jobs,Still in lab jobs and credit jobs.

For example

PH: Total Jobs =23559

Cancelled Jobs=55

Still in Lab=4

Credit Hold=0

GF:

Number of days - Number of Jobs

59

1 34

2 3

3 3

4 3

5 2

....

If you look at the example above that 59 is showing up with no days in front of it. This is coming up because I have not chosen an option which says "Discard all others". I would like to discard the rest however I have no idea how to do it when using a formula.

When I place the group and go into group options and it is set up as ascending, I cannot set it up as specified because then it will limit the number of days.

All I want to do is to discard those jobs which are either cancelled or still in lab or credits from the group.

How can I do this?

Please help.

Many thanks

Regards

Jehanzeb

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question