Incorrect Consolidated Data
Hello - we recently updated the stored values in the Percent Consolidation property in several large entity hierarchies, so there are 3 stored items with different time periods for each child. We fou...
Forum Discussion
Is there a reason why you're trying to validate future months that haven't had loaded data? Or is this more of a "why is this data being calculated" question? I ask because you've stated that you've "corrected" the future months by force consolidating but it's no longer working.
If it's "why is this data being calculated", my hunch is that the business rules you've got running are looking at the derived data and calculating ownership based on those values. So even though you haven't loaded data to June, the derived data shows a periodic change of 923k.
If your issue is strictly presentation, you can return zero (or whatever value you want) for the future months in a CV using an XFBR rule or possibly conditional formatting (if it's a future month, text color = transparent).
Yes, that's correct, its a question of why are we seeing these amounts in future months just for these 3 structures. I'll have our business rules reviewed, see if any recent changes were made. Thanks for your help!
