I can use the Next() and Prev() functions on date fields. I'd like to use them on number fields, and maybe even strings.
Some example use cases:
- ([Sum of Cost], Next([Product Code])) should return the (alphabetically) next product code.
- I have a [Fiscal Year] field. I want to filter on that, and then have a formula show me next year's value.
(And before you say "just use the standard datetime functions on a datetime field", I have different clients with different fiscal years, including one whose fiscal year start date changes year to year.) - I want to do a cumulative total.
