Former Member

Subtotal on every group code

Morning all,

I have created a report which is grouped by Reason Code (A numbering system 01- 999). This report produces Total Jobs, Total Lenses and their averages.

There is one slight addition I would like to add into the report.

I would like to create a formula so that report sub totals each record according to the code range.

For example:

When producing report for all codes (01- 999) It should produce results like this.

01 to 99

Sub Total

100 to 199

Sub total

200 - 299

Subtotal

and so on (upto 999).

Then Grand total of everything.

Any ideas how to achieve something like this?

Report Layout:

Grouped by - Reason code 01- 999

Group Header = Reason Code and Reason Description

Group Footer = Total Jobs, Total Lenses, Total Average

Report Footer = Total of Total Jobs, Total of Total Lenses and avg

Currently report when produced, it produces results like this

01 - 999

Total lenses, jobs and averages.

Hence there is no sub division between code ranges.

Many thanks

Regards

Jehanzeb

10|10000 characters needed characters exceeded

Former Member
Sep 02, 2008 at 12:04 PM

Hi Jehanzeb,

This can be done using a formula :

If Reason Code >= 0 and Reason Code <=99

Then "0 - 99"

Else If Reason Code >= 100 and Reason Code <=199

Then "100 - 199"

Else If Reason Code >=200 and Reason Code <=299

Then "200 - 299"

Else.........so on

Insert group based on this formula then you will get the required results.

Then you can insert group totals.

Hope this will resolve the issue.

Thanks,

Sastry

10|10000 characters needed characters exceeded
• Former Member Former Member

Thats exactly what I did.

It is working now, all I have to do is to create 8 new formulas which will count the sub total's total.

I have a grand total sorted as well.

Thanks all of you!

Regards

Jehanzeb