Skip to Content
avatar image
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.

Could someone advise me on this please?

Many thanks

Regards

Jehanzeb

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    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

    Add comment
    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