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

Options
justin.filip
justin.filip Member, ALL USERS Posts: 5 Contributor

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.