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. 


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



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