OFS_Total Plan is showing incorrect result with a scenario member formula
in Planning
Summary:
We have an integration which loads actuals into OFS_Load plan element.
We created a scenario member ActualPriorYr which is a store member to show prior year actuals. FS Formula shown below -
(@PRIOR ("OEP_Actual"->"OFS_Total Plan", 1, @LEVMBRS ("Years",0)));
We recently migrated from 25.10.76 to 26.07.
After that it started showing huge numbers. Upon drilling down to bottom, we observed that the value loaded into OFS_Load plan element is being show
for all the descendants of OFS_Total Plan and getting aggregated. We do not have data except at OFS_Load for OE_Actual which is 26,863 for FY25.
Tagged:
0