Function to return the number of leaf items in a standard or numbered list.

justin.filip

I think it would be very useful to have a function to return the number of leaf items present in a standard or numbered list.

 

Example:

 

QUANTITY(x) 

Where 'x' is the name of the list, also selectable from 'General Lists'.

 

Reasoning:

This would serve as a cleaner way to get the number of items in a list, instead of doing something like dimensionalizing a module by a list, creating a line item with '1' as the formula, setting the summary method to sum for that line item, then referencing that line item in a separate single-dimension module with one number formatted line item.

Miran

Status changed to: In Review

Rebecca

Status changed to: In Review

Alessio_Pagliano

@Miran @Rebecca , any updates on this ? In a way it's a type of request similar to this :

https://community.anaplan.com/discussion/38401/display-the-number-of-items-in-a-subset-and-line-item-subset