ACL doc

ACL doc

1)

Command: STATISTICS ON Amount TO SCREEN NUMBER 5
Table: Ar




Trans Amount




As of: Mar 04, 2014 01:16:56

Command: CLASSIFY ON Type SUBTOTAL Amount TO SCREEN
Table: Ar



Trans Type
Count
Percent of Count
Percent of Field
Trans Amount
AA
1
0.13%
-0.11%
(533.59)
CN
108
13.99%
-1.92%
(9,025.02)
IN
588
76.17%
112.02%
525,259.16
PM
71
9.2%
-9.66%
(45,281.38)
TR
4
0.52%
-0.33%
(1,538.48)
Totals
772
100%
100%
468,880.69

"We see that the number of transactions is 772 (609 +ve, 161 -ve and two Zeroes) , the highest is 5549.19 and the lowest is -3582.98, whereas we have a type of AA, has one value of -533.59, most of the transactions falls into IN (sales invoice)".






2) Command: STRATIFY ON Amount SUBTOTAL Amount INTERVALS 10 TO SCREEN
Table: Ar



Minimum encountered was (3,582.98)
Maximum encountered was 5,549.19


Trans Amount
Count
Percent of Count
Percent of Field
Trans Amount
(3,582.98) - (2,669.77)
1
0.13%
-0.76%
(3,582.98)
(2,669.76) - (1,756.55)
5
0.65%
-2.15%
(10,085.74)
(1,756.54) - (843.33)
18
2.33%
-4.67%
(21,877.18)
(843.32) - 69.88
190
24.61%
-4.5%
(21,092.73)
69.89 - 983.10
362
46.89%
42.9%
201,164.22
983.11 - 1,896.32
149
19.3%
41.92%
196,557.17
1,896.33 - 2,809.53
29
3.76%
13.59%
63,742.37
2,809.54 - 3,722.75
14
1.81%
9.65%
45,268.71
3,722.76 - 4,635.97
2
0.26%
1.77%
8,283.02
4,635.98 - 5,549.19
2
0.26%
2.24%
10,503.83
Totals
772
100%
100%
468,880.69
** For whole transactions

Command: STRATIFY ON Amount SUBTOTAL Amount INTERVALS 10 TO SCREEN
Table: Ar
Filter:
type= "IN" (588 records matched)

Minimum encountered was 6.66
Maximum encountered was 5,549.19

Trans Amount
Count
Percent of Count
Percent of Field
Trans Amount
6.66 - 560.91
199
33.84%
11.46%
60,170.15
560.92 - 1,115.16
219
37.24%
31.98%
167,960.58
1,115.17 - 1,669.41
106
18.03%
26.48%
139,093.90
1,669.42 - 2,223.67...

Similar Essays