Replace missing or Null values Option 1: Use ZN Select Analysis > Create Calculated Field In the Calculated Field dialog box that opens, do the following, and then click OK : Name the calculated field. In this example, the calculated field is named "Replace empty cells with zero (opt 1)" In the formula field, create a calculation similar to the following: ZN(SUM([Amount])) The ZN() function will replace any NULL values with zero Create a calculated field with a name like " Replace empty cells with last value (opt 1) " with a calculation similar to the following: IFNULL( SUM([Amount]), PREVIOUS_VALUE(0) ) IFNULL(..., PREVIOUS_VALUE(0)) will replace any NULL values with the last value of this calculation, which creates a running last value. Depending on how the view is built, it may be necessary to compute PREVIOUS_VALUE() differently. Replace [Amount] on Text on the Marks card with either [Replace em...