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

Options
CarlyBond
CarlyBond Member, ALL USERS, Community Member Posts: 4 Occasional Contributor
in Planning & Modeling

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

Tagged:

Comments

  • CarlyBond
    CarlyBond Member, ALL USERS, Community Member Posts: 4 Occasional Contributor

    Thank you for coming back to me so quickly 🙂

     

    This formula works, however, it includes the blank values. Is there any way in which I can ignore them?

     

    Apologies, I should have advised there were blank values in the first place.

  • CarlyBond
    CarlyBond Member, ALL USERS, Community Member Posts: 4 Occasional Contributor

    I don't think I have explained myself very well.

     

    Within Line Item 1, 2, 3, 4, etc there will always be a BLANK cell (i.e. There will only be one or two of the line items with something in them) so the MIN function is always returning a BLANK.

     

    Therefore the new MAX function is always returning BLANK too.

  • CarlyBond
    CarlyBond Member, ALL USERS, Community Member Posts: 4 Occasional Contributor

    Thank you so much, this does work.

Categories