Are NIL values supported?
Yes, Time Series API supports NIL via a NIL flag found in data objects. In formula code, the IsNIL() flag can be used to determine if a data object has its NIL flag set, as in the following code snippet: Double revenue = data(“revenue”); // Double expenses = data(“expenses”); // Double earnings = data(“earnings”); // possibly NIL Double earnings_fixed = If( IsNIL(earnings), revenue – expenses, earnings); //fixed The native database classes also support storage of NIL’s.
