First Non Blank within Hierarchy

howard
howard
edited November 2023 in Modeling
first non blank.jpg

Hi, how do I get the first non blank, or min, or max on the date here within the hierarchy. The first 3 lines should all have the same date 9/25

Answers

  • jon_mavetz
    jon_mavetz

    go to the blueprint view and change the summary method for those line items instead of writing that within the aggregation formula

  • anirudh
    anirudh

    You're 90% there already! For Rev Rec Start set the summary to whichever summary you need - Min, Max or Non Blank

    Create another line in this module and call it Parent Rev Rec Start

    Here's the formula for it:

    Rev Rec Start[LOOKUP: Parent]

Categories