Find earliest date and latest date in a non time dimensioned list

CommunityMember113484
CommunityMember113484
in Modeling

Hi,

I've got a module, dimensioned by a list (numbers), and line item with the dates of various cashflows. This module is not dimensioned by time.

How do I find the minimum value i.e. 23/04/08 and max value?

Any help is appreciated,
Thanks

image.png

Tagged:

Answers

  • BenjaminNiel
    BenjaminNiel

    Hi @CommunityMember113484,

    I see 2 ways to reach this:

    1. Add a top level to your list

    In General List, you can add a Top Level to your list

    image.png

    Then, add 2 line items "Min" and "Max" referencing "Date" but with the appropriate summary method

    image.png

    And the result:

    image.png

    OR

    2. Create a dummy list and use MIN/MAX aggregation functions

    Create a list with only 1 item

    image.png

    In your module, add a line item, dimensioned by the Dummy list and equal to the Dummy list item

    image.png

    In another module, dimensioned only with Dummy, reference the Date line item and use the MIN/MAX functions

    image.png

    And the result:

    image.png

    Hope this helps!

Categories