Automatically sum line items of a module

saket22

Is there a way to sum all the line items in a module? Let's say I have 20 line items in a module at the moment and I want to sum it all up in the 21st line item.

(1) Is selecting 20 line items one by one to get the total the only way?

(2) Is there a way to ensure that if a new line item is added somewhere between 1st and 20th line item, it is automatically added to the total formula?

JaredDolich

@saket22

I'm not aware of a single formula that will do that but there are alternatives. What you're describing sounds like a list. Is there a way you can convert the line items to a list. A line item subset won't help you either unfortunately, which converts line items to a list because there's not aggregate level. But, if you build a list instead of line items I think you'll get the desired effect - just make sure there's a top level (or parent).