SAP Knowledge Base Article - Public

3614754 - Error "Function "RESULTLOOKUP" is not supported in cross calculation. Please complete or rewrite the formula. " is displayed when trying to use "Resultlookup" function in cross calculations in an SAC story

Symptom

The below error is displayed when trying to use "Resultlookup" function in cross calculations in an SAC story:

"Function "RESULTLOOKUP" is not supported in cross calculation. Please complete or rewrite the formula." 

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Login into SAC.
  2. Create a new story.
  3. Create a calculation from a cross calculation and use the function "Resultlookup".
    >> Notice the error "Function "RESULTLOOKUP" is not supported in cross calculation. Please complete or rewrite the formula. " 

Cause

  • Currently, it is a by design behavior in SAC.
  • "Resultlookup" function is not supported in cross calculations.

Resolution

  • At the moment there is no plan on the roadmap to change this behavior in SAC.
  • To request a new feature or product enhancement, SAP has defined a process and tool that is now available to customers called Idea Place: https://influence.sap.com/sap/ino/. Idea Place gives customers the ability to log their own Enhancement Requests and work more directly with our Technology and Development group.

    SAP is committed to reviewing and responding to the ideas submitted on a regular basis. The ideas with the most votes will receive a higher level of attention for response and consideration. The processes and procedures associated with this site will continue to evolve and enhance over time. Refer to Knowledge Base Article 1515837 for more details.

Keywords

SAPCloudAnalytics, System, Data, User, CloudAnalytics, Cloud for Analytics, Issue, Story, Working, failure  , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , Problem

Product

SAP Analytics Cloud 1.0