Find the minimum 'Month' across multiple Line Items within the same module
Apologies if this doesn't make much sense but I am fairly new to Anaplan.
I have a module with multiple line items, each retrieving a month from other modules (Formatted to Time Period: Month). I would now like another Line Item (within the same module) to calculate the 'MIN' of those line items. Is this possible?
I have tried MIN('Line Item 1', 'Line Item 2', 'Line Item 3') but this comes up with a formatting error (even though it is formatted as Time Period: Month)