XNPV Returns the present value for a schedule of cash flows that is not necessarily periodic.
XNPV(table, values, dates, rate)
ShowAllColumn – A column for which to return items with no data for the measures used.
Table – A table containing all items with data (NON EMPTY) for the measures used.
GroupingColumn – A column which is used to group by in the supplied table argument.
isSubtotal_columnName – A Boolean column in the supplied table argument which contains ISSUBTOTAL values for the corresponding groupingColumn column.
FilterTable – A table representing filters to include in the logic for determining whether to add specific combinations of items with no data. Used to avoid having ADDMISSINGITEMS add in item combinations which are not present because they were removed by a filter.
Net present value.