TM1 Function for TI, NValue 

A TM1 reserved local variable.

What is the NValue function?

NValue is a TM1 reserved local variable. We don’t need to define this variable to use it in the TM1 script. However, we can only use this variable when the DatasourceType is cube view and the current cell value is numeric. 

Where can the NValue function be used?


Which TM1 Server version is this function available for?

Version 11 and 12

What is the syntax for NValue?


A demonstration on how to use NValue

Using the Product Scorecard cube, whenever the value is a numeric, export to a text file.