Error Spreadsheet Functions
| DPL | Excel | Meaning |
|---|---|---|
| @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
See Also