SAP Knowledge Base Article - Public

2925233 - Null entries in CSV and XLSX export cannot do calculations


  • Problems with calculations and formulas  
  • User cannot execute formulas on empty data cells in CSV and XLSX exports


  • SAP Analytics Cloud (SAC)


"Null" or "Blank" or "Empty" cells are valid data entries, but these cells are not equivalent to the value 0.


Convert blank cells into zeroes before executing formulas or calculations.

  1. Insert column
  2. Fill in a formula that checks: If cell is blank, fill it with zero, else fill it with cell entry
    1. Formula: =IF(<cell> = "blank", 0, <cell>)
  3. Use new column for formulas and calculations

See Also


Microsoft Excel, Comma Seperated Values, Separated , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-AD , Analytics Designer , LOD-ANA-TAB , Table , How To


SAP Analytics Cloud 1.0