SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • SAP Analytics Cloud (SAC)

Cause

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

Resolution

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

 https://www.sapanalytics.cloud/resources-working-with-formulas/

Keywords

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

Product

SAP Analytics Cloud 1.0