3386232 - Formula Bar Calculated Column Disappears After Applying a Filter in SAP Analytics Cloud (SAC)

• Formula Bar calculated column disappears after applying a Filter.
• The Filter modifies the original number of columns of the Table, on a Story in SAP Analytics Cloud.

• Sap Analytics Cloud 2023.16

1. Insert a Table into a Story, in SAP Analytics Cloud.
2. Create a Formula Bar calculated column based on data in the Table.
3. Apply a Filter to the table.
   • Note: This can be a Story, Page, or Table filter.
4. Notice the Formula Bar calculated column disappears.

• This issue happens when the filter modifies the number of columns in the Table.
  • This can occur if the filtered subset of data has a column of null values. This would result in Null Suppression removing the column entirely.

• An intended Table may be achievable by disabling Null Suppression and manually filtering undesired (null data populated) members and/or columns.

• Formula Bar: Add Calculated Rows and Columns
• Builder Panel: Table Structure - Null Suppression
• Create Calculated Dimensions for Tables

formula bar, calculated column, filter, disappear, calculated dimension, , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-TAB , Table , Problem