Using "Pct" for Net Change Ratios

 

SEE ALSO: Using "Pct" for Percentage of Gross Income

The Pct field can also be used to calculate a ratio between two columns on a report. Using the Pct field in the column you wish to divide by, enter the column number to be divided into. The system will take the difference between the two columns and divide by the column you are in.

For example, if you are working in column 1, and want to know the net change ratio between this column and column 2, enter “2” in the Pct field for column 1. The calculation will be as follows:

(Column 2 - Column 1) ÷ Column 1

On the printed report, the heading “2-1/1” will appear to explain the calculation. Be sure to check the heading to make sure the correct field was used. A common mistake is to use the Pct field on the wrong column. This will show up in the heading (e.g., “2-1/2”) as being divided by the wrong column.

IMPORTANT: The figures generated by this field will only appear on printed reports, not inquiry screens.

Sample

In the following example, column 1 will show current month figures (December 2001) and column 2 will show previous month figures (November). Between the columns you will see a percentage calculated as (Column 2 - Column 1) ÷ Column 1.

images\method7intopicg_shg.gif

A final report would look similar to this (only a portion of the report is shown here):

 

                                                             CURRENT       2-1/1          PREVIOUS

                                                              PERIOD        PCT            PERIOD

                                                       -----------------   ------   -----------------

              INCOME

     111-00    INT INCOME / SIGNATURE LOANS PART SECU          82,012.44-     2.2-%         80,150.84-

     111-01    INT INCOME - BUSINESS REAL ESTATE PART              66.66       .0 %             66.66

     111-02    N/A                                                   .00       .0 %               .00

     111-03    INT INCOME - SHARE PLEDGE LOANS                  2,118.56-      .6 %          2,132.00-

     111-04    INT INCOME - SIGNATURE LOANS                    80,255.33-     7.4-%         74,298.83-

     111-05    INT INCOME - STOCK LOANS                              .00       .0 %               .00

     111-06    INT INCOME - PAYMENT SHAVER LOANS                     .00       .0 %               .00

     111-07    INT INCOME - PAYMENT SHAVER USED                      .00       .0 %               .00

     111-08    INT INCOME - BUS ADJ RATE MORTGAGE               5,546.79-     2.2-%          5,424.35-

     111-09    VIP LOAN INTEREST REBATES                       15,107.95      4.2-%         14,467.79

     111-10    PAYMENT SHAVER PREMIUM                                .00       .0 %               .00

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#using_pct_for_net_change_ratios.htm