No of sums in a single line item

Hi,

Need to know that how many number of sums we can use in a single line item so that its performance will also won't downgraded.

Thanks,

Vicky

Accepted answers

All comments

umangsinghal

Performance depends on the various factors like size of modules used in Sum, Summary methods, Multiple If else statements. There is no straight forward answer to the number of SUM can be used in a line item, you can test the performance in real time environment. If it affects the performance, try to break the formula in multiple lineitem.

rob_marshall

@Vicky_Kapri

It really depends on what you are asking…

If you are asking how many sums in a particular statement like line item[sum:x, sum:y, sum:z] then you are obviously limited to the number of lists/dimensions defined for that line item.
if you are asking how many sum statements within a line item like line item1[sum:X] + line item2[sum:y] + line item3[sum:z] then yes, it does make a difference. Best Practice (link) says to break them up. The reason for this, when something changes in line item1, the sums for line item2 and line item3 get kicked off as well. Also, please remember, even though the logic is defined once, it is getting kicked off for every cell associated with that line item. For example, if the cell count for that line item is 1M cells, that formula is getting kicked off 1M times.
If you are asking how many line items doing SUMS within a module, it depends on the sums. If they are similar (the sums) with only the line item changing, then it would be best to look into using a line item subset and a calculation module (do the sum once, and then reference the results).

Hope this helps,

Rob

Quick Links

Can you help?

Unanswered questions

A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385