SAP Knowledge Base Article - Preview

3146693 - REF_ERR in Average formula when the story is filtered by a year


  • Created a formula to show Average value of the range of the cells for multiple years(2020, 2021, 2022 for example). The story refreshes correctly. 
  • When a filter is applied to select one specific year(2021, for example), it cause the widget to refresh, the cell references in the formula shows REF_ERR.



  • SAP Analytics Cloud (Enterprise) 2021.20.25 (Client) & 2021.20.22 (Server)


SAP Analytics Cloud 1.0


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-TAB , Table , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.