Working with Data ModelsCreating ModelsModeling MetricsAdd CalculationsMDX ReferenceNULLIFZERO(scalar)On this pageNULLIFZERO(scalar) Returns a scalar converted to NULL if the scalar input was zero. Syntax NULLIFZERO(scalar) Input parameters scalar Required. An MDX scalar expression such as a metric, calculation, or constant. Example lineitem.avg_order_size AS ROUND(sales / NULLIFZERO(order_count), 2)