Next and Prev on number fields
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.
Tim von Ahsen
Posted 11 months ago·Last reply 11 months ago
1 comment
Tim von Ahsen
OP11 months agoAlso, please throw an error when I try to use Next or Prev on an invalid data type. Returning sometimes-right, sometimes-wrong data is confusing people.