SAP Knowledge Base Article - Public

3206599 - YTD Calculation with null values show no data (-)


Based on import connection.

The calculation for YTD is not working properly when the current date is selected and the transactional data for the current date is null (in the current month there were no values), but in the previous months have values. To make it more clear, a screenshot from the data source is displayed bellow the KPI's.

The first KPI "sales YTD for Actual (Column B)" shows exactly the issue. In this KPI Instead of the dash, is expected to see the 250 value as it is presented in the second KPI which refers to Column C from the data source. The difference between column "B" and "C" is that in the 202204 have null values for col "B" and "0" in column "C". Only KPI related to column "C" shows the correct number. 


SAP Analytics Cloud (2022.8.7)

Reproducing the Issue

  1. Open the Tenant URL.

  2. Go to the Story that contains a Calculation YTD and null values on the same data source. (Values + Null Values)

  3. Charts or Tables that contain this Calculation show no data (-).


This issue is currently under investigation by Development.


This issue is currently under investigation by Development.

Workaround: Populate the null data with "0".

See Also


SAPCloudAnalytics, SAP Analytics Cloud, Error, Issue, Data, Sac, Acquisition, Up, Set, setup, Model, Story, Tenant, Import, Failed, Using, Working, sapanalyticscloud, sap analyst cloud, accumulation, calculation, aggregation, sum, YTD, Year to date , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud all versions