RPAS Cloud: Workbook with Sum(Over Calculation) Calculations May Result in Zero or Missing Data
(Doc ID 2974641.1)
Last updated on FEBRUARY 24, 2025
Applies to:
Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version 23.1 to 23.2 [Release 23.1 to 23.2]Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service - Version 23.1 to 23.2 [Release 23.1 to 23.2]
Oracle Retail Demand Forecasting Cloud Service Plus - Version 23.1 to 23.2 [Release 23.1 to 23.2]
Information in this document applies to any platform.
Symptoms
The results of the example calculation below should be accumulated value relative to the previous period. However the measure results are not correct.
MEASUREABCD = tssum(MEASUREDEFG, first, current)
A different example with the same results.
MEASUREXYZ = if(current == today, tssum(MEASUREKLM, first, current), if (MEASURESTUElapB, 0, if(current > today, MEASURELMN, ignore)))
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |