Module line item sizing

ChrisG532

I have a module dimensioned by Articles (3056 cells), Versions, and Months over 5 years.

Versions has 8 elements,

Months has 60 elements.

If I run with No Versions the total cell size is 183,360 (ie. 3056 x 60 x 1).

I expect 8 Versions to 1466880. But the model tells me it is 1347696 cells.

Why the difference?

Accepted answers

All comments

andrewtye

Have you got any versions using switchover date - not exactly sure how it works but data from actual version in forecast versions count "less".

@rob_marshall - this is right isn't it?

rob_marshall

@andrewtye you nailed it…If you are using switchover, the Actuals part will be less for the other versions because it is referencing the data. Also, as the switchover date increases throughout the year, it will be more noticeable because you have more "actuals" in the other versions.

Quick Links

Can you help?

Unanswered questions

Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Problem with the Excel plugin and exiting Excel
Hello, we have a problem with the ExcelAddin 4.4 and Excel 365 for Enterprise. Once the plugin is installed and we open / close Excel, an invisible Excel process remains and doesn't close. Because of this, very often we have the message "Do you want to start in safe mode?" next time we start excel (especially after a…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!