I am trying to figure out how I can perform a calculation on data in the same column but different rows.
| Tail # |
AFH |
Added QTY |
Current AFH |
HRS Between Oil Addition |
Liters/10Hrs
(Max=1.42) |
| 156101 |
7249.7 |
1.0 |
7272.7 |
33.7 |
0.297 |
| 156101 |
7216.0 |
1.0 |
7272.7 |
25.3 |
0.395 |
| 156101 |
7190.7 |
1.0 |
7272.7 |
|
|
|
|
|
|
|
|
| 156102 |
8439.1 |
1.0 |
8461.2 |
|
|
|
|
|
|
|
|
| 156105 |
9252.8 |
1.0 |
9267.1 |
22.0 |
0.455 |
| 156105 |
9230.8 |
1.0 |
9267.1 |
|
|
|
|
|
|
|
|
| 156106 |
8288.9 |
1.0 |
8303.2 |
3.5 |
2.857 |
| 156106 |
8285.4 |
1.0 |
8303.2 |
|
|
This is an Excel version of what I want my Crystal to be able to do.
The first 4 columns are the results set .
The 'HRS Between Oil Addition' and the 'Liters/10 HRS' columns are calculated.
HRS Between Oil Addition column = AFH(x) - AFH(y). If row y is blank then the column is left blank as well.
The Liters/10 HRS = QTY Added(x) / HRS Between Oil Addition(x). If HRS Between Oil Addition is blank then the column is left blank.
Any suggestions on how I can accomplish this in Crystal??
Thanks!
Ace
IP Logged
