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?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.