When I apply semi-additives and apply Average, total amount at Year Total get divided by 12 irrespective of Missing or Zero's in Months.
Similarly for last, if value exists only from Jan to May, Amounts of Mar goes to Qtr1 and May to Qtr2 Howeve...
Support for Calculated Fields in Views in the Excel 365 Add-in
Enable support for calculated fields in Views to allow dynamic data manipulation directly within the Excel Add-In. This functionality would empower users to perform advanced calculations using Views content and dynamically expand/collapse them bas...
Improve Posting Journal with better user experience
Posting Journal improvement:
- Response time for the posting journal report is too high
- Better data validation to upload journal
- Carry forward jounarls- in Lucanet only values and link to original journal to drill down
Problem Statement: The current Intercompany Matrix Report is not loading with more number of legal entities. Recommendation: Change/ Create a new report layout with Legal Entity and Partner Entity in rows, IC Account/ Consolidation rules in column...
Workflow to support >1000 base elements in step dimension
The finished state in workflow is hardcoded to be 1000. This is per KB. The issue is that when there are >1000 elements in the step dimension, the calculation of the finished and active rates will be wrongly calculated. With increasingly larger...
Journal Validation to work, even customised to integrate Segment Consolidation Ledger to Balance Sheet Cube, instead of Balance Sheet (Segment) Cube
Problem Statement: When the segment consolidation ledger is customised to use Balance Sheet cube instead of Balance Sheet (Segment) cube, journals do not pass data validation when segment-related fields are blank
Users should be able to not commit their numbers immediately after writing
When planning users should be able to not commit their numbers immediately after writing them as this automatically refreshes their data and interrupts their workflow. Similar to creating a hold, users should be able to enter multiple cells and de...
More and more clients seem to be leveraging Google sheets instead of Excel. Anaplan is pursuing this strongly, and we need to consider making this an option as well.