Discard all others

[Former Member]

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

[Former Member · Accepted solution]

Hi Jehanzeb

Try writing a formula that would deduct the number of

cancelled jobs, still in lab jobs and credit jobs from the total number of jobs and then apply the group based on this formula.

Hope this helps!!!

Regards

Sourashree

[Former Member · Accepted solution]

hi Sourashee, that is what I am currently doing. lets see if that works.

Will update this section.

Regards

Jehanzeb

[Former Member · Accepted solution]

Sourashee,

I have created a formula which calculates the total number of Others (Credit,Canceled,On Hold) however when I try to subtract that from the Total Jobs under number of jobs formula it does not work.

here is my formula for couting total Others

Whileprintingrecords;
Numbervar j:={#Cancelled Orders};
Numbervar f:={#Still in Lab};
numbervar d:={#Credit Hold};
Numbervar c:=(j+f+d);
c;

Here how I tried to use to subtract the total Others from total jobs.

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

however this didn't work.

Could you please help me getting this right?

Regards

Jehanzeb