Calculations with formulas

How to: annualize a monthly P/P series with a formula? change the color of a series when it’s below / above 0 (or any other value)? create an if condition/statement? create a continuous growth rate? combine an if condition/statement with the logical operators and/or? disaggregate a series? make an index out of P/P series? replace … Continue reading “Calculations with formulas”

How to replace all missing values in a series with a 0?

There are two main possibilities to achieve this: 1. The Conversion settings tab in Series List You can set the ‘Missing Value Method’ as ‘Zero Value’. 2. Formula You can also use the formula: Null0(series) For more information: Formula analysis