SAP Knowledge Base Article - Public

3034409 - currency conversion involved with account formula in SAC


currency conversion result incorrect in SAC


  • SAP Analytics Cloud

Reproducing the Issue

1. Account A with formula referring to Account B

2. Account B customized with a LOOKUP formula with Date Dimension referring to a date. [For example, preivous year]

3. Currency Convertion on Account A

4. Instead of using rate in current year, the system is using the rate in the previous year from Account B


Standard Behavior


  1. Currency conversion is executed prior to account formula
  2. account formula operates based on the currency conversion's output
  3. in this example, the currency conversion on account B executes first, so the rate is referring to the previous year, and then account A gets the converted result from account B. 


    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,  currency, rate, exchange, translation, , KBA , LOD-ANA-PL , Planning , Problem


    SAP Analytics Cloud 1.0