The 4th parameter

The 4th parameter can be used to address problems concerning references out of range. References to cells not available in the current dataset (e.g. a reference to previous month in the first month of a dataset). Such a reference would normally result in the error message “not defined”, but with the 4th parameter you have the option to insert a value instead of the not-reachable value.

The syntax could be: sum(d1, -1, m1, 0). This reference to the previous row will (in case previous row is not-reachable) return a zero instead.

Was this article helpful?
1 out of 2 found this helpful



Please sign in to leave a comment.