2792311 - RESULTLOOKUP formula returns message "Member must be a leaf member" if member is not base level in SAP Analytics Cloud (SAC)

RESULTLOOKUP formula in Advanced Formula returns message "Member must be a leaf member" if member is not base level.

• SAP Analytics Cloud 2019.9

1. Create a new Data Action
2. Add Advanced Formula step
3. Add a RESULTLOOKUP formula that references a parent member.

This is a current restriction of Resultlookup function in Data Action.

The feature to Support Parent/Formula member in Resultlookup in Data Action is in our backlog for future consideration.

The workaround for the moment is to manually calculate sum of all the children members in the Data Action.

• How to find User Assistance for SAP Analytics Cloud?
• Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
• SAP Analytics Cloud > Learning > Guided Playlists

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

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem