SAP Knowledge Base Article - Public

3046162 - Using filters in the RESULTLOOKUP clause does not return the correct result

Symptom

Using filters in the RESULTLOOKUP clause does not return the correct result.

Environment

  • SAP Analytics Cloud (Enterprise) 2021.2.11

Reproducing the Issue

1. Create an Advanced Formula in a data action

example: RESULTLOOKUP([d/Account]="Account name", [d/Version]="public.name", [d/AuditTrail]="AuditTrail name"])

2. Execute the data action.

3. The generated value is not correct. The value is three time more of the correct value.

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-AF , Advanced Formulas , Problem

Product

SAP Analytics Cloud 1.0