Hello,
Need help. I need to count based on the 'field 2' segmentation. Every time when there is a F or G criteria change in field 2 then output should be in the following series. I tried using multi row formula with if condition. However, my requirement not met because of string conversion error.
| Record Number | Field 1 | Field 2 | Output |
| 1 | A | F | 1 |
| 2 | B | F | 2 |
| 3 | C | F | 3 |
| 4 | D | F | 4 |
| 5 | E | F | 5 |
| 6 | A | G | 1 |
| 7 | B | G | 2 |
| 8 | C | G | 3 |
| 9 | D | G | 4 |
| 10 | A | G | 1 |
| 11 | B | G | 2 |
| 12 | C | G | 3 |
| 13 | D | G | 4 |
| 14 | A | F | 1 |
| 15 | B | F | 2 |
| 16 | C | F | 3 |
| 17 | D | F | 4 |
| 18 | E | F | 5 |
| 19 | A | G | 1 |
| 20 | B | G | 2 |
| 21 | C | G | 3 |
| 22 | D | G | 4 |
