This function is used to return the difference between the band index of the same record on different bands. See earlier description of BANDINDEX function.
TRACKFIELD ( <banding_name>, <banding_name> )
- banding name: The first banding to use.
- banding name: The second banding to use.
Example: Create field on the CUSTOMER that shows the how many spend bands a customer has moved between 2000 and 2001. Create field on the CUSTOMER that shows the how many spend bands a customer has moved between 2000 and 2001.
TRACKFIELD ( [CUSTOMER.SUM 2000], [CUSTOMER.SUM 2001] )