Next and Prev on number fields | Product Feedback Forum

Tim von Ahsen · 2025-09-11T04:42:49.398000Z

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.

MoreDiscussions

Next and Prev on number fields | Product Feedback Forum | Sisense Community