Symptom
In Measure Calculation value is not shown correctly when if value is null and ''Use current date/time if NULL or empty date'' option is checked
Environment
- SAP Sales Cloud and SAP Service Cloud Version 2
- Embedded usage of SAP Analytics Cloud
Reproducing the Issue
- Logon to Sale Cloud V2.
- After login, click the user icon in the top & right, choose System Settings.
- Go to All Settings -> Analytics -> Design Stories
- Open problem story
- When value is null 'Use current date/time if NULL or empty date'
- The calculated is wrong if we count when date value is null
Cause
The "Use current date/Time if Null" option appends the current date with a default timestamp of 00:00:00 to make it a complete timestamp. This behavior is by design.
Resolution
- Note that the "Use current date/Time if Null" option appends the current date with a default timestamp of 00:00:00.
- If the requirement is to use the actual current time instead of 00:00:00, this functionality is not supported in the current design.
Keywords
time difference, date difference, use current date/time, null timestamp, SAC story calculations, incorrect time difference, default timestamp, 00:00:00, enhancement request, influence portal, calculated measure. , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , Problem
Product
SAP Sales Cloud and SAP Service Cloud Version 2 1.0
SAP Knowledge Base Article - Public