How do I change the "NA" or "0" value for a metric item?

When defining a plottable, you can choose if a component should register as a 0 or NA if missing in the data source. For example, if a definition component is dividends, but a subject company does not pay dividends, you can choose to set the non-applicable value as 0 instead of NA so a null result isn’t produced for the plottable.

To do this:

1. Select the definition from Definitions in the Data Hub. 

2. Hover toward the right of the table and click the pencil icon. This will open the definition editor. 

na-values1.png


3. In the definition editor, 
toggle between 0 and NA in the NA value= column next to the definition. 

na-values.png

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request