Symptom
- Creating a formula that contains LastPeriods results in error if the period is defined dynamically.
- For example: LOOKUP([AMT], [d/Time] = LastPeriods ("Month",[NUM]))
- For such a formula to work, the number must be defined within the formula.
- It doesn't work if it references a measure.
- Even if the measure contains numbers, SAP Analytics Cloud does not accept the formula and provides an error message: "Formula could not be computed: Function LastPeriods expects parameter 2 of type "Number", but receives "Number"; try using the expected parameter type. Try rewriting the formula."
Read more...
Environment
- SAP Analytics Cloud 2018.18
Product
SAP Analytics Cloud 1.0
Keywords
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
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.