Error Spreadsheet Functions
|@na||NA( )||The error "no value is available."|
When DPL encounters this function during analysis, it will terminate with the message "@na encountered during execution" and provide the name of the variable.
There are four ways for DPL to encounter @na during evaluation:
- During spreadsheet conversion, DPL replaces unsupported functions with @na.
- During array formula evaluation, DPL fills unfilled rows or columns of the result array with @na.
- During array evaluation, DPL fills array elements with @na when the element expression contains an error (for example, requires division by 0).
- During evaluation of any expression in which you have coded an @na function.
Versions: DPL Professional, DPL Enterprise, DPL Portfolio