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
- Login into SAC.
- Create a new story.
- 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