Hi-
The preceding-sibling expression depends on:
1. your data source - perhaps you can attach a screenshot?
2. the location where the formula is used. Is it bound to a field, is it a calculated value, etc?
Can you provide these details? That should help to try and debug this.
Thanks.