Find the minimum 'Month' across multiple Line Items within the same module

[CarlyBond]

Hi,

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)

Any help would be greatly received.

Regards

Carly

[Kanishq17]

@CarlyBond 

You need to convert month into dates using start() , then get the minumum date in another line item, then get month back using period()

here l1,l2,l3 are your month time formatted line items, get minimum date in min date which is date formatted, then convert date to month using period function

attaching blueprint