DiscardNull will replace any Null values with zero. The use of this function is for cases where you use expressions that can't use Null values.



Input Data*

Defines the time series data fed into the function. This can be a sensor ID or another function.

*Input data is optional in most cases. If Info360 detects that the first input is time series data, it will be applied to the function. Otherwise, the current active sensor's data will be used, which is often the case in Reference Charts.

Example Usage as an Expression:

DiscardNull(Sensor('BCB_Station.Pressure')) - Replace any Null values in the 'BCB_Station.Pressure' sensor data stream.

Note that you can use IIF function to find Null values as well as assign Null to values you want to throw out from your analysis.

IIF(Close()*0!=0, 0, Close()) - This function does the same thing as DiscardNull().

IIF(ROC(2)>0.1,'', Close()) - This example will throw away (assign Null) any values with a ROC greater than 10% from the previous value, and leave the rest.

Examples Reference Chart:

The following the DiscardNull function being used

For information on setting up custom equations and syntax, please refer to Analytical Functions.