SAP Knowledge Base Article - Public

2885915 - LOOKUP formula to create the last months' values and aggregates to hierarchy does not work unless all the dates are in the table

Symptom

  • LOOKUP formula to create the last months' values and aggregates to hierarchy does not work unless all the dates are in the table.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.2.2

Reproducing the Issue

  • Create a story with the formual to use LOOKUP formula to create the last months' values and aggregates to a hierarchy and divides the number of months.
  • The formula does not show the values unless all the dates are in the table. 

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

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-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0