Defining How Horizontal Value Functions Treat Null Values

If checked, horizontal value functions are calculated using zero (0) for parameters with no value/null value whenever possible. Checking this checkbox has no effect on indicator functions.

If the box is not checked, horizontal functions operating on cells containing a null value cannot be calculated. This generates an error message that is written in the function log.

Note: This option does not apply to Advanced Functions as it is possible to correctly treat null values in the advanced code. For more information on advanced functions see Advanced Function, in Working with Categories.

Related Topics

The Defaults Tab

Accessing the Defaults Tab

Viewing First Quarter Start Day

Defining the User Name Format

Editing the Reports Header

Setting the Maximum Search Results

Setting Investor Map Defaults

Enabling Auto Renaming for Duplicate Names

Configuring Indicators

Defining Dependency Defaults

Customizing the Branding Strip

Defining How to Treat Blank Scorecard Values

Editing the Regional Options



Legal Notices | Your Privacy Rights
Copyright © 1998, 2020

Last Published Thursday, December 10, 2020