question911
MIS
Crystal 9 and Oracle 9i
I need help with a formula that increments a counter whenever the value on a field from the previous record is not the same value, otherwise the counter retains the value from the most recent increment. For Example, lets say the table looks like this.....
ID Type
100 ABC
100 BBB
100 CCC
101 VVV
101 TTT
102 FFF
The formula should display the following for each record:
0
0
0
1
1
2
Hope this made sense.
I need help with a formula that increments a counter whenever the value on a field from the previous record is not the same value, otherwise the counter retains the value from the most recent increment. For Example, lets say the table looks like this.....
ID Type
100 ABC
100 BBB
100 CCC
101 VVV
101 TTT
102 FFF
The formula should display the following for each record:
0
0
0
1
1
2
Hope this made sense.