New function to calculate 'Inception to Date'


It appears that there is no out-of-the-box function to sum all values up to the current period to return the 'inception to date' value. A new function could be very similar to MONTHTODATE and YEARTODATE but calculate from the start of the time range up to the current period (potentially with optional offset arguments).


This would be very useful for calculating closing balances where flows in each period are known and you need to sum them all to get the closing value.

1 votes

New · Last Updated


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!