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)
Re: Find the minimum 'Month' across multiple Line Items within the same module
Create an equivalent number of number formatted line items as the number of month formatted line items Use the formula MONTH(Month1LineItem) for the first line item MONTH(Month2LineItem) for the second line item and so on
Finally, create a min line item and point it to the newly created number formatted line items.