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.
SAP Knowledge Base Article - Preview