3664833 - YTD measure discrepancy in SAP.GETDATA formula in SAP Analytics Cloud, add-in for Microsoft Office

• A calculated measure is created in the SAC model to display the YTD data. Its formula is similar as ITERATE(IF([d/Date].[p/MONTHDESC]="",0 ,PRIOR() )+[Amount] ,[Amount],[d/Date].[p/CALMONTH] ) 
• The YTD measure in an SAC Add-in Excel workbook is not displaying the total YTD values but instead shows the monthly amount.
• The YTD value retrieved using the SAP.GETDATA formula does not match the expected total YTD value.
• The issue is inconsistent, with the YTD formula working correctly in some cases but failing in others.
• The issue is observed in both the SAC Add-in workbook and SAC story when the table filter is set to a specific month (e.g., 202502).
• The issue does not happen in the SAC Add-in workbook and SAC story when the table filter is set to the whole year (e.g., 2025).

SAP Analytics Cloud, add-in for Microsoft Office

ytd calculation, sac add-in, sap.getdata formula, SAP.GETDATA() formula, GETDATA, sac excel workbook, sac integration, dynamic time calculation, sac ytd issue, sac table filter, sac calculated measures, ytd formula redesign, sac performance optimization, year to date, year-to-date, time dimension, sac excel addin , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , LOD-ANA-TAB , Table , LOD-ANA-DES-CAL , SAC Story Calculations , Problem