New function to calculate 'Inception to Date'

Options
OliverMunns
OliverMunns Member, ALL USERS Posts: 5 Contributor
in Planning & Modeling

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.

Tagged:

Categories