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

CarlyBond
Occasional Contributor

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

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

10 REPLIES 10
Kanishq17
Community Boss

@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()

Kanishq17_0-1592480119966.png

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

Kanishq17_1-1592480205782.png

attaching blueprint